changeset 1021:f51a9cf1d52c schema-update

Update data files.
author Raimund Renkert <raimund.renkert@intevation.de>
date Mon, 04 Jul 2016 14:11:00 +0200
parents 178ac8ee17c0
children 042437ce8f51
files db_schema/lada_data.sql db_schema/stammdaten_data.sql
diffstat 2 files changed, 267 insertions(+), 454 deletions(-) [+]
line wrap: on
line diff
--- a/db_schema/lada_data.sql	Mon Jul 04 12:10:44 2016 +0200
+++ b/db_schema/lada_data.sql	Mon Jul 04 14:11:00 2016 +0200
@@ -28,63 +28,63 @@
 
 ALTER TABLE probe DISABLE TRIGGER ALL;
 
-COPY probe (id, test, netzbetreiber_id, mst_id, labor_mst_id, hauptproben_nr, datenbasis_id, ba_id, probenart_id, media_desk, media, umw_id, probeentnahme_beginn, probeentnahme_ende, mittelungsdauer, letzte_aenderung, erzeuger_id, probe_nehmer_id, mp_kat, mpl_id, mpr_id, solldatum_beginn, solldatum_ende, tree_modified) FROM stdin;
-660	f	12	12020	12020	N0013KE12	2	1	1	D: 01 03 52 02 00 00 00 00 00 00 00	Schafkäse	N92	2012-01-26 11:30:00+01	\N	\N	2012-02-22 12:38:39	\N	784	1	\N	\N	2012-01-01 00:00:00	2012-01-31 21:59:59	2016-03-17 09:19:04.94469
-409	f	12	12010	12010	A0239MP12	2	U	1	D: 01 02 07 03 00 00 00 00 00 00 00	Magermilchpulver	N94	2012-03-15 11:00:00+01	\N	\N	2012-03-26 16:31:35	\N	1199	U	\N	\N	2012-03-01 00:00:00	2012-03-31 21:59:59	2016-03-17 09:19:04.94469
-42	f	06	06010	06010	120109003	2	1	1	D: 01 03 26 03 04 02 00 00 00 00 00	Frischkäse Fettstufe auch mit Gewürzen/Kräutern	N91	2012-01-04 08:00:00+01	\N	\N	2012-01-23 08:48:21	\N	734	1	\N	\N	2012-01-01 00:00:00	2012-01-31 21:59:59	2016-03-17 09:19:04.94469
-313	f	11	11010	11010	122200001	2	1	1	D: 01 06 35 04 01 02 02 20 00 00 00	Suppenhuhn auch tiefgefroren	N54	2012-02-24 09:30:00+01	2012-02-24 09:30:00+01	\N	2012-03-01 13:35:02	\N	\N	1	\N	\N	2012-01-01 00:00:00	2012-12-31 21:59:59	2016-03-17 09:19:04.94469
-311	f	11	11010	11010	122100011	2	1	1	D: 01 06 40 04 01 02 02 11 00 00 00	Fleischteilstück Reh auch tiefgefroren	N56	2012-06-04 10:00:00+02	2012-06-04 10:00:00+02	\N	2012-06-18 08:47:25	\N	\N	1	\N	\N	2012-01-01 00:00:00	2012-06-30 21:59:59	2016-03-17 09:19:04.94469
-112	f	11	11010	11010	122800001	2	1	1	D: 01 01 01 02 01 02 00 20 00 00 00	Milch ab Hof	A13	2012-01-10 09:30:00+01	2012-01-10 09:30:00+01	\N	2016-03-07 10:29:55.669	\N	\N	1	\N	\N	2012-01-09 00:00:00	2012-01-15 21:59:59	2016-03-17 09:19:04.94469
-117	f	06	06060	06060	14206	2	1	1	D: 01 01 01 01 02 00 00 00 00 00 00	Sammelmilch	N11	2012-01-25 11:00:00+01	\N	\N	2012-01-27 17:04:47	553	727	1	\N	\N	2012-01-23 00:00:00	2012-01-29 21:59:59	2016-03-17 09:19:04.94469
-307	f	11	11010	11010	122100004	2	1	1	D: 01 06 16 19 01 02 02 20 00 00 00	Schnitzel Schwein auch tiefgefroren	N53	2012-02-24 09:30:00+01	2012-02-24 09:30:00+01	\N	2012-03-01 13:35:02	\N	\N	1	\N	\N	2012-01-01 00:00:00	2012-03-31 21:59:59	2016-03-17 09:19:04.94469
-203	f	11	11010	11010	122400003	2	1	1	D: 01 10 29 50 01 02 05 01 02 00 00	Schleie (Tinca tinca) Süßwasserfisch	N61	2012-06-01 09:00:00+02	2012-06-01 09:00:00+02	\N	2012-06-11 11:16:53	\N	\N	1	\N	\N	2012-03-26 00:00:00	2012-12-09 21:59:59	2016-03-17 09:19:04.94469
-357	f	06	06010	06010	120110255	2	1	1	D: 01 12 01 13 04 02 02 00 00 00 00	Tiefseegarnele (Pandalus sp.)	N63	2012-01-10 10:00:00+01	\N	\N	2012-01-19 11:08:01	\N	734	1	\N	\N	2012-01-01 00:00:00	2012-01-31 21:59:59	2016-03-17 09:19:04.94469
-292	f	11	11010	11010	121300007	2	1	1	D: 01 15 01 01 01 02 01 00 00 00 00	Weizenkörner	N31	2012-01-27 10:15:00+01	2012-01-27 10:15:00+01	\N	2012-02-01 09:11:02	\N	\N	1	\N	\N	2012-01-01 00:00:00	2012-12-31 21:59:59	2016-03-17 09:19:04.94469
-294	f	11	11010	11010	121300009	2	1	1	D: 01 15 06 03 01 02 01 00 00 00 00	Langkornreis	N3Z	2012-01-27 10:45:00+01	2012-01-27 10:45:00+01	\N	2012-02-01 09:12:36	\N	\N	1	\N	\N	2012-01-01 00:00:00	2012-12-31 21:59:59	2016-03-17 09:19:04.94469
-25	f	06	06010	06010	120614003	2	1	1	D: 01 29 01 02 00 00 00 00 02 00 00	Erdbeere	N44	2012-06-14 08:00:00+02	\N	\N	2012-06-19 09:32:23	\N	92	1	\N	\N	2012-07-01 00:00:00	2012-07-31 21:59:59	2016-03-17 09:19:04.94469
-145	f	06	06010	06010	120425002	2	1	1	D: 01 24 01 02 04 00 00 00 00 00 00	Kartoffel festkochend (Salatware)	N25	2012-04-24 11:00:00+02	\N	\N	2012-06-12 13:43:03	\N	734	1	\N	\N	2012-04-01 00:00:00	2012-04-30 21:59:59	2016-03-17 09:19:04.94469
-4	f	06	06010	06010	120619003	2	1	1	D: 01 25 01 01 00 00 00 00 02 00 00	Kopfsalat	N21	2012-06-18 09:30:00+02	\N	\N	2012-06-20 08:55:23	\N	78	1	\N	\N	2012-06-01 00:00:00	2012-07-31 21:59:59	2016-03-17 09:19:04.94469
-140	f	06	06010	06010	120109006	2	1	1	D: 01 25 03 02 04 02 00 00 02 00 00	Gemüsepaprika	N23	2012-01-04 06:30:00+01	\N	\N	2012-01-23 14:52:40	\N	734	1	\N	\N	2012-01-01 00:00:00	2012-01-31 21:59:59	2016-03-17 09:19:04.94469
-284	f	11	11010	11010	121100004	2	1	1	D: 01 25 04 06 01 02 02 00 02 00 00	Radieschen	N22	2012-06-04 09:30:00+02	2012-06-04 09:30:00+02	\N	2012-06-11 11:16:53	\N	\N	1	\N	\N	2012-05-21 00:00:00	2012-07-01 21:59:59	2016-03-17 09:19:04.94469
-703	f	06	06010	06010	120426001	2	1	1	D: 01 27 08 03 01 00 02 00 00 00 00	Speisemorchel (Morchella esculenta)	N2A	2012-04-24 22:00:00+02	\N	\N	2012-04-26 13:00:15	\N	977	1	716	\N	2012-01-10 00:00:00	2012-01-10 21:59:59	2016-03-17 09:19:04.94469
-301	f	11	11010	11010	121200009	2	1	1	D: 01 29 01 14 01 02 02 00 00 00 00	Moosbeere	N46	2012-01-27 10:30:00+01	2012-01-27 10:30:00+01	\N	2012-02-06 09:04:26	\N	\N	1	\N	\N	2012-01-01 00:00:00	2012-12-31 21:59:59	2016-03-17 09:19:04.94469
-300	f	11	11010	11010	121200008	2	1	1	D: 01 29 02 01 01 02 02 00 00 00 00	Apfel	N42	2012-01-27 10:45:00+01	2012-01-27 10:45:00+01	\N	2012-02-01 09:14:31	\N	\N	1	\N	\N	2012-01-01 00:00:00	2012-12-31 21:59:59	2016-03-17 09:19:04.94469
-24	f	06	06010	06010	120619004	2	1	1	D: 01 29 03 07 00 00 00 00 00 00 00	Süßkirsche	N43	2012-06-18 11:30:00+02	\N	\N	2012-06-20 08:56:20	\N	78	1	\N	\N	2012-06-01 00:00:00	2012-06-30 21:59:59	2016-03-17 09:19:04.94469
-296	f	11	11010	11010	121200002	2	1	1	D: 01 29 05 14 01 02 02 00 02 00 00	Rhabarber	N4Z	2012-05-07 10:10:00+02	2012-05-07 10:10:00+02	\N	2012-05-15 08:27:55	\N	\N	1	\N	\N	2012-08-06 00:00:00	2012-10-21 21:59:59	2016-03-17 09:19:04.94469
-99	f	11	11010	11010	123100001	2	1	3	D: 01 50 90 01 06 02 05 00 00 00 00 51	Tageskost einschl. flüssiger Bestandteile und Getränke	N81	2012-01-03 23:00:00+01	2012-01-04 22:00:00+01	82800	2012-01-23 08:56:08	\N	\N	1	\N	\N	2012-01-02 00:00:00	2012-01-15 21:59:59	2016-03-17 09:19:04.94469
-194	f	11	11010	11010	125500001	2	1	1	D: 01 59 01 01 05 02 03 03 01 01 00	Rohwasser aus Grundwasser nicht aufbereitet	G51	2012-03-02 12:10:00+01	2012-03-02 12:10:00+01	\N	2012-03-22 08:12:08	\N	\N	1	\N	\N	2012-01-09 00:00:00	2012-04-01 21:59:59	2016-03-17 09:19:04.94469
-3	f	06	06010	06010	120515001	2	1	1	D: 01 59 03 01 01 02 05 01 02 00 00	Trinkwasser Zentralversorgung Grundwasser aufbereitet	N71	2012-05-10 11:00:00+02	\N	\N	2012-05-30 13:21:12	\N	716	1	\N	\N	2012-05-07 00:00:00	2012-05-13 21:59:59	2016-03-17 09:19:04.94469
-1	f	06	06010	06010	120510002	2	1	1	D: 01 59 04 01 00 05 05 01 02 00 00	Trinkwasser Zentralversorgung Oberflächenwasser aufbereitet	N72	2012-05-08 11:00:00+02	\N	\N	2012-06-13 08:51:46	\N	726	1	\N	\N	2012-05-07 00:00:00	2012-05-13 21:59:59	2016-03-17 09:19:04.94469
-31	f	06	06010	06010	120210003	2	1	1	D: 01 59 05 01 05 05 05 01 02 00 00	Trinkwasser aus Mischwasser Zentralversorgung aufbereitet	N73	2012-02-07 23:00:00+01	\N	\N	2012-03-02 12:40:21	\N	724	1	\N	\N	2012-02-06 00:00:00	2012-02-12 21:59:59	2016-03-17 09:19:04.94469
-84	f	06	06010	06010	120404004	2	1	1	D: 04 01 98 01 00 00 23 07 00 72 03	Unbearbeiteter Boden	B33	2012-04-02 12:30:00+02	\N	\N	2012-04-23 12:32:56	\N	60	1	\N	\N	2012-04-02 00:00:00	2012-04-08 21:59:59	2016-03-17 09:19:04.94469
-76	f	06	06010	06010	120326001	2	1	1	D: 04 01 42 28 00 00 10 08 00 31 03	Unbearbeiteter Boden	B31	2012-03-26 09:00:00+02	\N	\N	2012-04-18 11:47:05	\N	813	1	\N	\N	2012-04-02 00:00:00	2012-04-08 21:59:59	2016-03-17 09:19:04.94469
-88	f	06	06010	06010	120326002	2	1	1	D: 04 01 24 84 00 00 60 15 00 31 07	Unbearbeiteter Boden	B34	2012-03-26 10:40:00+02	\N	\N	2012-04-18 11:47:21	\N	813	1	\N	\N	2012-04-02 00:00:00	2012-04-08 21:59:59	2016-03-17 09:19:04.94469
-180	f	11	11010	11010	126100037	2	1	1	D: 06 04 05 01 00 00 00 02 01 01 00	Sediment	G13	2012-03-12 10:30:00+01	2012-03-12 10:30:00+01	\N	2012-03-20 12:20:47	\N	\N	1	\N	\N	2012-01-01 00:00:00	2012-03-31 21:59:59	2016-03-17 09:19:04.94469
-97	f	06	06010	06010	120306001	2	1	3	D: 06 05 00 01 00 00 00 06 00 00 01	Schwebstoffe	G12	2012-01-24 09:00:00+01	2012-02-24 09:00:00+01	2678400	2012-03-09 08:51:44	\N	60	1	\N	\N	2012-01-23 00:00:00	2012-02-19 21:59:59	2016-03-17 09:19:04.94469
-91	f	06	06060	06060	14246	2	1	1	D: 06 02 00 01 00 00 01 02 02 00 00	Oberflächenwasser	G11	2012-02-13 11:00:00+01	\N	\N	2012-03-02 11:00:40	553	60	1	\N	\N	2012-02-13 00:00:00	2012-02-19 21:59:59	2016-03-17 09:19:04.94469
-186	f	11	11010	11010	126100049	2	1	1	D: 06 05 00 02 00 00 00 01 00 00 00	Schwebstoffe	G22	2012-03-06 11:00:00+01	2012-03-06 11:00:00+01	\N	2012-03-12 09:23:31	\N	\N	1	\N	\N	2012-01-01 00:00:00	2012-03-31 21:59:59	2016-03-17 09:19:04.94469
-174	f	11	11010	11010	126100025	2	1	1	D: 06 04 05 02 00 00 00 02 01 01 00	Sediment	G23	2012-03-06 11:00:00+01	2012-03-06 11:00:00+01	\N	2012-03-20 12:20:47	\N	\N	1	\N	\N	2012-01-01 00:00:00	2012-03-31 21:59:59	2016-03-17 09:19:04.94469
-160	f	11	11010	11010	126100001	2	1	3	D: 06 02 00 02 00 00 01 04 02 00 00	Oberflächenwasser	G21	2012-01-17 11:00:00+01	2012-03-13 11:00:00+01	4838400	2012-03-22 08:12:08	\N	\N	1	\N	\N	2012-01-01 00:00:00	2012-03-31 21:59:59	2016-03-17 09:19:04.94469
-200	f	11	11010	11010	125500010	2	1	1	D: 06 03 00 01 00 00 01 03 00 00 00	Grundwasser	G41	2012-04-27 07:00:00+02	2012-04-27 07:00:00+02	\N	2012-05-30 09:36:31	\N	\N	1	\N	\N	2012-01-01 00:00:00	2012-06-30 21:59:59	2016-03-17 09:19:04.94469
-45	f	06	06010	06010	120120005	2	1	1	D: 08 01 03 01 00 00 00 06 00 00 00	Abwasser	A11	2012-01-19 06:00:00+01	\N	\N	2012-02-01 13:30:03	\N	60	1	\N	\N	2012-01-09 00:00:00	2012-01-15 21:59:59	2016-03-17 09:19:04.94469
-55	f	06	06010	06010	120120006	2	1	1	D: 08 02 04 01 00 00 04 02 00 00 00	Schlamm aus Abwässern	A13	2012-01-19 07:00:00+01	\N	\N	2012-02-02 13:38:43	\N	60	1	\N	\N	2012-01-09 00:00:00	2012-01-15 21:59:59	2016-03-17 09:19:04.94469
-69	f	06	06010	06010	120309008	2	1	1	D: 09 01 16 01 00 00 00 00 00 00 00	Reststoffe aus Verbrennungsanlagen	A23	2012-03-09 11:30:00+01	\N	\N	2012-03-15 10:33:22	\N	813	1	\N	\N	2012-03-05 00:00:00	2012-03-11 21:59:59	2016-03-17 09:19:04.94469
-67	f	06	06010	06010	120309009	2	1	1	D: 09 01 07 01 00 00 00 00 00 00 00	Reststoffe aus Verbrennungsanlagen	A22	2012-03-09 11:30:00+01	\N	\N	2012-03-15 10:33:31	\N	813	1	\N	\N	2012-03-05 00:00:00	2012-03-11 21:59:59	2016-03-17 09:19:04.94469
-70	f	06	06010	06010	120309004	2	1	1	D: 09 01 14 05 00 00 00 00 00 00 00	Reststoffe aus Verbrennungsanlagen	A24	2012-03-07 09:00:00+01	\N	\N	2012-03-15 10:32:18	\N	60	1	\N	\N	2012-03-05 00:00:00	2012-03-11 21:59:59	2016-03-17 09:19:04.94469
-65	f	06	06010	06010	120309005	2	1	1	D: 09 01 02 05 00 00 00 00 00 00 00	Reststoffe aus Verbrennungsanlagen	A21	2012-03-07 09:00:00+01	\N	\N	2012-03-15 12:09:13	\N	60	1	\N	\N	2012-03-05 00:00:00	2012-03-11 21:59:59	2016-03-17 09:19:04.94469
-78	f	06	06010	06010	120330006	2	1	1	D: 04 02 42 26 00 00 01 25 00 31 03	Ackerboden	B32	2012-03-28 11:00:00+02	\N	\N	2012-04-20 12:45:31	\N	60	1	\N	\N	2012-04-02 00:00:00	2012-04-08 21:59:59	2016-03-17 09:19:04.94469
-36	f	06	06010	06010	120502004	2	1	1	D: 01 48 25 04 02 00 00 00 00 00 00	Milch für die besondere Ernährung von Kleinkindern	N82	2012-04-27 08:00:00+02	\N	\N	2012-09-18 12:41:00	\N	729	1	\N	\N	2012-04-01 00:00:00	2012-04-30 21:59:59	2016-03-17 09:19:04.94469
-157	f	11	11010	11010	125100001	2	1	1	D: 02 01 01 01 00 02 00 00 00 00 00 21 00 00 00 01 00 00 00 00 00 00 00 00	Grünfutter	A3	2012-05-21 09:30:00+02	2012-05-21 09:30:00+02	\N	2016-03-07 11:04:15.14	\N	\N	1	\N	\N	2012-04-16 00:00:00	2012-06-17 21:59:59	2016-03-17 09:19:04.94469
-19	f	06	06010	06010	120614002	2	1	1	D: 01 25 02 25 00 00 00 00 02 00 00	Spargel, weiß	N24	2012-06-14 07:00:00+02	\N	\N	2012-06-19 09:31:23	\N	92	1	\N	\N	2012-06-01 00:00:00	2012-06-30 21:59:59	2016-03-17 09:19:04.94469
-707	f	11	11010	11010	125100012	2	1	1	D: 02 02 20 00 00 02 00 00 00 00 00	Silagen	F5Z	2012-01-11 10:00:00+01	2012-01-11 10:00:00+01	\N	2012-01-23 08:56:08	\N	\N	1	\N	\N	\N	\N	2016-03-17 09:19:04.94469
-158	f	11	11010	11010	125100007	2	1	1	D: 02 06 48 00 00 01 00 00 00 00 00	Nebenerzeugnisse trocken	F62	2012-01-27 10:15:00+01	2012-01-27 10:15:00+01	\N	2012-02-06 08:59:59	\N	\N	1	\N	\N	2012-01-01 00:00:00	2012-12-31 21:59:59	2016-03-17 09:19:04.94469
-155	f	11	11010	11010	125300001	2	1	1	D: 03 09 01 00 00 00 00 00 00 00 00	Pflanzliche Indikatoren	I13	2012-05-14 10:00:00+02	2012-05-14 10:00:00+02	\N	2012-05-30 12:04:35	\N	\N	1	\N	\N	2012-05-07 00:00:00	2012-09-30 21:59:59	2016-03-17 09:19:04.94469
-73	f	06	06060	06060	14360	2	1	1	D: 09 03 00 00 00 00 00 00 00 00 00	Kompostierung	A41	2012-05-10 10:00:00+02	\N	\N	2012-05-24 12:45:00	553	813	1	\N	\N	2012-05-07 00:00:00	2012-05-13 21:59:59	2016-03-17 09:19:04.94469
-71	f	06	06010	06010	120523008	2	1	1	D: 09 02 08 00 00 00 00 00 00 00 00	Deponie	A31	2012-05-11 10:30:00+02	\N	\N	2012-06-04 14:03:58	\N	813	1	\N	\N	2012-05-07 00:00:00	2012-05-13 21:59:59	2016-03-17 09:19:04.94469
-354	f	06	06010	06010	120110258	2	1	1	D: 01 10 55 00 00 00 00 00 00 00 00	Barschartige Fische Seefische Zuschnitte	N62	2012-01-10 09:00:00+01	\N	\N	2012-01-19 10:55:44	\N	734	1	\N	\N	2012-01-01 00:00:00	2012-01-31 21:59:59	2016-03-17 09:19:04.94469
-353	f	06	06010	06010	120117004	2	1	1	D: 01 06 23 00 05 02 02 00 00 00 00	Fleischteilstücke Lamm/Schaf auch tiefgefroren	N55	2012-01-17 10:00:00+01	\N	\N	2012-01-26 13:03:27	\N	734	1	\N	\N	2012-01-01 00:00:00	2012-06-30 21:59:59	2016-03-17 09:19:04.94469
-147	f	06	06060	06060	14242	2	1	1	D: 01 06 02 00 00 00 00 00 00 00 00	Fleischteilstücke Rind auch tiefgefroren	N51	2012-02-22 11:00:00+01	\N	\N	2012-02-29 14:45:58	553	714	1	\N	\N	2012-02-01 00:00:00	2012-02-29 21:59:59	2016-03-17 09:19:04.94469
-406	f	12	12020	12020	N0198FU12	2	1	1	D: 02 01 16 00 00 00 00 00 00 00 00	Grünfutter	F12	2012-06-07 09:00:00+02	\N	\N	2012-07-12 11:32:17	\N	1859	1	\N	\N	2012-04-01 00:00:00	2012-06-30 21:59:59	2016-03-17 09:19:04.94469
+COPY probe (id, id_alt, test, mst_id, labor_mst_id, hauptproben_nr, datenbasis_id, ba_id, probenart_id, media_desk, media, umw_id, probeentnahme_beginn, probeentnahme_ende, mittelungsdauer, letzte_aenderung, erzeuger_id, probe_nehmer_id, mpl_id, mpr_id, solldatum_beginn, solldatum_ende, tree_modified) FROM stdin;
+660	000007590041X	f	12020	12020	N0013KE12	2	1	1	D: 01 03 52 02 00 00 00 00 00 00 00	Schafkäse	N92	2012-01-26 11:30:00+01	\N	\N	2012-02-22 12:38:39	\N	784	\N	\N	2012-01-01 00:00:00	2012-01-31 21:59:59	2016-03-17 09:19:04.94469
+409	000007589343X	f	12010	12010	A0239MP12	2	U	1	D: 01 02 07 03 00 00 00 00 00 00 00	Magermilchpulver	N94	2012-03-15 11:00:00+01	\N	\N	2012-03-26 16:31:35	\N	1199	\N	\N	2012-03-01 00:00:00	2012-03-31 21:59:59	2016-03-17 09:19:04.94469
+42	000007578227X	f	06010	06010	120109003	2	1	1	D: 01 03 26 03 04 02 00 00 00 00 00	Frischkäse Fettstufe auch mit Gewürzen/Kräutern	N91	2012-01-04 08:00:00+01	\N	\N	2012-01-23 08:48:21	\N	734	\N	\N	2012-01-01 00:00:00	2012-01-31 21:59:59	2016-03-17 09:19:04.94469
+313	000007575969X	f	11010	11010	122200001	2	1	1	D: 01 06 35 04 01 02 02 20 00 00 00	Suppenhuhn auch tiefgefroren	N54	2012-02-24 09:30:00+01	2012-02-24 09:30:00+01	\N	2012-03-01 13:35:02	\N	\N	\N	\N	2012-01-01 00:00:00	2012-12-31 21:59:59	2016-03-17 09:19:04.94469
+311	000007575967X	f	11010	11010	122100011	2	1	1	D: 01 06 40 04 01 02 02 11 00 00 00	Fleischteilstück Reh auch tiefgefroren	N56	2012-06-04 10:00:00+02	2012-06-04 10:00:00+02	\N	2012-06-18 08:47:25	\N	\N	\N	\N	2012-01-01 00:00:00	2012-06-30 21:59:59	2016-03-17 09:19:04.94469
+112	000007575752X	f	11010	11010	122800001	2	1	1	D: 01 01 01 02 01 02 00 20 00 00 00	Milch ab Hof	A13	2012-01-10 09:30:00+01	2012-01-10 09:30:00+01	\N	2016-03-07 10:29:55.669	\N	\N	\N	\N	2012-01-09 00:00:00	2012-01-15 21:59:59	2016-03-17 09:19:04.94469
+117	000007578031X	f	06060	06060	14206	2	1	1	D: 01 01 01 01 02 00 00 00 00 00 00	Sammelmilch	N11	2012-01-25 11:00:00+01	\N	\N	2012-01-27 17:04:47	553	727	\N	\N	2012-01-23 00:00:00	2012-01-29 21:59:59	2016-03-17 09:19:04.94469
+307	000007575960X	f	11010	11010	122100004	2	1	1	D: 01 06 16 19 01 02 02 20 00 00 00	Schnitzel Schwein auch tiefgefroren	N53	2012-02-24 09:30:00+01	2012-02-24 09:30:00+01	\N	2012-03-01 13:35:02	\N	\N	\N	\N	2012-01-01 00:00:00	2012-03-31 21:59:59	2016-03-17 09:19:04.94469
+203	000007575864X	f	11010	11010	122400003	2	1	1	D: 01 10 29 50 01 02 05 01 02 00 00	Schleie (Tinca tinca) Süßwasserfisch	N61	2012-06-01 09:00:00+02	2012-06-01 09:00:00+02	\N	2012-06-11 11:16:53	\N	\N	\N	\N	2012-03-26 00:00:00	2012-12-09 21:59:59	2016-03-17 09:19:04.94469
+357	000007578195X	f	06010	06010	120110255	2	1	1	D: 01 12 01 13 04 02 02 00 00 00 00	Tiefseegarnele (Pandalus sp.)	N63	2012-01-10 10:00:00+01	\N	\N	2012-01-19 11:08:01	\N	734	\N	\N	2012-01-01 00:00:00	2012-01-31 21:59:59	2016-03-17 09:19:04.94469
+292	000007575939X	f	11010	11010	121300007	2	1	1	D: 01 15 01 01 01 02 01 00 00 00 00	Weizenkörner	N31	2012-01-27 10:15:00+01	2012-01-27 10:15:00+01	\N	2012-02-01 09:11:02	\N	\N	\N	\N	2012-01-01 00:00:00	2012-12-31 21:59:59	2016-03-17 09:19:04.94469
+294	000007575941X	f	11010	11010	121300009	2	1	1	D: 01 15 06 03 01 02 01 00 00 00 00	Langkornreis	N3Z	2012-01-27 10:45:00+01	2012-01-27 10:45:00+01	\N	2012-02-01 09:12:36	\N	\N	\N	\N	2012-01-01 00:00:00	2012-12-31 21:59:59	2016-03-17 09:19:04.94469
+25	000007587696X	f	06010	06010	120614003	2	1	1	D: 01 29 01 02 00 00 00 00 02 00 00	Erdbeere	N44	2012-06-14 08:00:00+02	\N	\N	2012-06-19 09:32:23	\N	92	\N	\N	2012-07-01 00:00:00	2012-07-31 21:59:59	2016-03-17 09:19:04.94469
+145	000007578087X	f	06010	06010	120425002	2	1	1	D: 01 24 01 02 04 00 00 00 00 00 00	Kartoffel festkochend (Salatware)	N25	2012-04-24 11:00:00+02	\N	\N	2012-06-12 13:43:03	\N	734	\N	\N	2012-04-01 00:00:00	2012-04-30 21:59:59	2016-03-17 09:19:04.94469
+4	000007587554X	f	06010	06010	120619003	2	1	1	D: 01 25 01 01 00 00 00 00 02 00 00	Kopfsalat	N21	2012-06-18 09:30:00+02	\N	\N	2012-06-20 08:55:23	\N	78	\N	\N	2012-06-01 00:00:00	2012-07-31 21:59:59	2016-03-17 09:19:04.94469
+140	000007578082X	f	06010	06010	120109006	2	1	1	D: 01 25 03 02 04 02 00 00 02 00 00	Gemüsepaprika	N23	2012-01-04 06:30:00+01	\N	\N	2012-01-23 14:52:40	\N	734	\N	\N	2012-01-01 00:00:00	2012-01-31 21:59:59	2016-03-17 09:19:04.94469
+284	000007575917X	f	11010	11010	121100004	2	1	1	D: 01 25 04 06 01 02 02 00 02 00 00	Radieschen	N22	2012-06-04 09:30:00+02	2012-06-04 09:30:00+02	\N	2012-06-11 11:16:53	\N	\N	\N	\N	2012-05-21 00:00:00	2012-07-01 21:59:59	2016-03-17 09:19:04.94469
+703	000007590316X	f	06010	06010	120426001	2	1	1	D: 01 27 08 03 01 00 02 00 00 00 00	Speisemorchel (Morchella esculenta)	N2A	2012-04-24 22:00:00+02	\N	\N	2012-04-26 13:00:15	\N	977	716	\N	2012-01-10 00:00:00	2012-01-10 21:59:59	2016-03-17 09:19:04.94469
+301	000007575950X	f	11010	11010	121200009	2	1	1	D: 01 29 01 14 01 02 02 00 00 00 00	Moosbeere	N46	2012-01-27 10:30:00+01	2012-01-27 10:30:00+01	\N	2012-02-06 09:04:26	\N	\N	\N	\N	2012-01-01 00:00:00	2012-12-31 21:59:59	2016-03-17 09:19:04.94469
+300	000007575949X	f	11010	11010	121200008	2	1	1	D: 01 29 02 01 01 02 02 00 00 00 00	Apfel	N42	2012-01-27 10:45:00+01	2012-01-27 10:45:00+01	\N	2012-02-01 09:14:31	\N	\N	\N	\N	2012-01-01 00:00:00	2012-12-31 21:59:59	2016-03-17 09:19:04.94469
+24	000007587691X	f	06010	06010	120619004	2	1	1	D: 01 29 03 07 00 00 00 00 00 00 00	Süßkirsche	N43	2012-06-18 11:30:00+02	\N	\N	2012-06-20 08:56:20	\N	78	\N	\N	2012-06-01 00:00:00	2012-06-30 21:59:59	2016-03-17 09:19:04.94469
+296	000007575943X	f	11010	11010	121200002	2	1	1	D: 01 29 05 14 01 02 02 00 02 00 00	Rhabarber	N4Z	2012-05-07 10:10:00+02	2012-05-07 10:10:00+02	\N	2012-05-15 08:27:55	\N	\N	\N	\N	2012-08-06 00:00:00	2012-10-21 21:59:59	2016-03-17 09:19:04.94469
+99	000007575726X	f	11010	11010	123100001	2	1	3	D: 01 50 90 01 06 02 05 00 00 00 00 51	Tageskost einschl. flüssiger Bestandteile und Getränke	N81	2012-01-03 23:00:00+01	2012-01-04 22:00:00+01	82800	2012-01-23 08:56:08	\N	\N	\N	\N	2012-01-02 00:00:00	2012-01-15 21:59:59	2016-03-17 09:19:04.94469
+194	000007575847X	f	11010	11010	125500001	2	1	1	D: 01 59 01 01 05 02 03 03 01 01 00	Rohwasser aus Grundwasser nicht aufbereitet	G51	2012-03-02 12:10:00+01	2012-03-02 12:10:00+01	\N	2012-03-22 08:12:08	\N	\N	\N	\N	2012-01-09 00:00:00	2012-04-01 21:59:59	2016-03-17 09:19:04.94469
+3	000007581040X	f	06010	06010	120515001	2	1	1	D: 01 59 03 01 01 02 05 01 02 00 00	Trinkwasser Zentralversorgung Grundwasser aufbereitet	N71	2012-05-10 11:00:00+02	\N	\N	2012-05-30 13:21:12	\N	716	\N	\N	2012-05-07 00:00:00	2012-05-13 21:59:59	2016-03-17 09:19:04.94469
+1	000007581034X	f	06010	06010	120510002	2	1	1	D: 01 59 04 01 00 05 05 01 02 00 00	Trinkwasser Zentralversorgung Oberflächenwasser aufbereitet	N72	2012-05-08 11:00:00+02	\N	\N	2012-06-13 08:51:46	\N	726	\N	\N	2012-05-07 00:00:00	2012-05-13 21:59:59	2016-03-17 09:19:04.94469
+31	000007578204X	f	06010	06010	120210003	2	1	1	D: 01 59 05 01 05 05 05 01 02 00 00	Trinkwasser aus Mischwasser Zentralversorgung aufbereitet	N73	2012-02-07 23:00:00+01	\N	\N	2012-03-02 12:40:21	\N	724	\N	\N	2012-02-06 00:00:00	2012-02-12 21:59:59	2016-03-17 09:19:04.94469
+84	000007578312X	f	06010	06010	120404004	2	1	1	D: 04 01 98 01 00 00 23 07 00 72 03	Unbearbeiteter Boden	B33	2012-04-02 12:30:00+02	\N	\N	2012-04-23 12:32:56	\N	60	\N	\N	2012-04-02 00:00:00	2012-04-08 21:59:59	2016-03-17 09:19:04.94469
+76	000007578301X	f	06010	06010	120326001	2	1	1	D: 04 01 42 28 00 00 10 08 00 31 03	Unbearbeiteter Boden	B31	2012-03-26 09:00:00+02	\N	\N	2012-04-18 11:47:05	\N	813	\N	\N	2012-04-02 00:00:00	2012-04-08 21:59:59	2016-03-17 09:19:04.94469
+88	000007578316X	f	06010	06010	120326002	2	1	1	D: 04 01 24 84 00 00 60 15 00 31 07	Unbearbeiteter Boden	B34	2012-03-26 10:40:00+02	\N	\N	2012-04-18 11:47:21	\N	813	\N	\N	2012-04-02 00:00:00	2012-04-08 21:59:59	2016-03-17 09:19:04.94469
+180	000007575819X	f	11010	11010	126100037	2	1	1	D: 06 04 05 01 00 00 00 02 01 01 00	Sediment	G13	2012-03-12 10:30:00+01	2012-03-12 10:30:00+01	\N	2012-03-20 12:20:47	\N	\N	\N	\N	2012-01-01 00:00:00	2012-03-31 21:59:59	2016-03-17 09:19:04.94469
+97	000007578331X	f	06010	06010	120306001	2	1	3	D: 06 05 00 01 00 00 00 06 00 00 01	Schwebstoffe	G12	2012-01-24 09:00:00+01	2012-02-24 09:00:00+01	2678400	2012-03-09 08:51:44	\N	60	\N	\N	2012-01-23 00:00:00	2012-02-19 21:59:59	2016-03-17 09:19:04.94469
+91	000007578319X	f	06060	06060	14246	2	1	1	D: 06 02 00 01 00 00 01 02 02 00 00	Oberflächenwasser	G11	2012-02-13 11:00:00+01	\N	\N	2012-03-02 11:00:40	553	60	\N	\N	2012-02-13 00:00:00	2012-02-19 21:59:59	2016-03-17 09:19:04.94469
+186	000007575831X	f	11010	11010	126100049	2	1	1	D: 06 05 00 02 00 00 00 01 00 00 00	Schwebstoffe	G22	2012-03-06 11:00:00+01	2012-03-06 11:00:00+01	\N	2012-03-12 09:23:31	\N	\N	\N	\N	2012-01-01 00:00:00	2012-03-31 21:59:59	2016-03-17 09:19:04.94469
+174	000007575807X	f	11010	11010	126100025	2	1	1	D: 06 04 05 02 00 00 00 02 01 01 00	Sediment	G23	2012-03-06 11:00:00+01	2012-03-06 11:00:00+01	\N	2012-03-20 12:20:47	\N	\N	\N	\N	2012-01-01 00:00:00	2012-03-31 21:59:59	2016-03-17 09:19:04.94469
+160	000007575783X	f	11010	11010	126100001	2	1	3	D: 06 02 00 02 00 00 01 04 02 00 00	Oberflächenwasser	G21	2012-01-17 11:00:00+01	2012-03-13 11:00:00+01	4838400	2012-03-22 08:12:08	\N	\N	\N	\N	2012-01-01 00:00:00	2012-03-31 21:59:59	2016-03-17 09:19:04.94469
+200	000007575856X	f	11010	11010	125500010	2	1	1	D: 06 03 00 01 00 00 01 03 00 00 00	Grundwasser	G41	2012-04-27 07:00:00+02	2012-04-27 07:00:00+02	\N	2012-05-30 09:36:31	\N	\N	\N	\N	2012-01-01 00:00:00	2012-06-30 21:59:59	2016-03-17 09:19:04.94469
+45	000007578239X	f	06010	06010	120120005	2	1	1	D: 08 01 03 01 00 00 00 06 00 00 00	Abwasser	A11	2012-01-19 06:00:00+01	\N	\N	2012-02-01 13:30:03	\N	60	\N	\N	2012-01-09 00:00:00	2012-01-15 21:59:59	2016-03-17 09:19:04.94469
+55	000007578259X	f	06010	06010	120120006	2	1	1	D: 08 02 04 01 00 00 04 02 00 00 00	Schlamm aus Abwässern	A13	2012-01-19 07:00:00+01	\N	\N	2012-02-02 13:38:43	\N	60	\N	\N	2012-01-09 00:00:00	2012-01-15 21:59:59	2016-03-17 09:19:04.94469
+69	000007578287X	f	06010	06010	120309008	2	1	1	D: 09 01 16 01 00 00 00 00 00 00 00	Reststoffe aus Verbrennungsanlagen	A23	2012-03-09 11:30:00+01	\N	\N	2012-03-15 10:33:22	\N	813	\N	\N	2012-03-05 00:00:00	2012-03-11 21:59:59	2016-03-17 09:19:04.94469
+67	000007578283X	f	06010	06010	120309009	2	1	1	D: 09 01 07 01 00 00 00 00 00 00 00	Reststoffe aus Verbrennungsanlagen	A22	2012-03-09 11:30:00+01	\N	\N	2012-03-15 10:33:31	\N	813	\N	\N	2012-03-05 00:00:00	2012-03-11 21:59:59	2016-03-17 09:19:04.94469
+70	000007578289X	f	06010	06010	120309004	2	1	1	D: 09 01 14 05 00 00 00 00 00 00 00	Reststoffe aus Verbrennungsanlagen	A24	2012-03-07 09:00:00+01	\N	\N	2012-03-15 10:32:18	\N	60	\N	\N	2012-03-05 00:00:00	2012-03-11 21:59:59	2016-03-17 09:19:04.94469
+65	000007578279X	f	06010	06010	120309005	2	1	1	D: 09 01 02 05 00 00 00 00 00 00 00	Reststoffe aus Verbrennungsanlagen	A21	2012-03-07 09:00:00+01	\N	\N	2012-03-15 12:09:13	\N	60	\N	\N	2012-03-05 00:00:00	2012-03-11 21:59:59	2016-03-17 09:19:04.94469
+78	000007578303X	f	06010	06010	120330006	2	1	1	D: 04 02 42 26 00 00 01 25 00 31 03	Ackerboden	B32	2012-03-28 11:00:00+02	\N	\N	2012-04-20 12:45:31	\N	60	\N	\N	2012-04-02 00:00:00	2012-04-08 21:59:59	2016-03-17 09:19:04.94469
+36	000007578214X	f	06010	06010	120502004	2	1	1	D: 01 48 25 04 02 00 00 00 00 00 00	Milch für die besondere Ernährung von Kleinkindern	N82	2012-04-27 08:00:00+02	\N	\N	2012-09-18 12:41:00	\N	729	\N	\N	2012-04-01 00:00:00	2012-04-30 21:59:59	2016-03-17 09:19:04.94469
+157	000007575772X	f	11010	11010	125100001	2	1	1	D: 02 01 01 01 00 02 00 00 00 00 00 21 00 00 00 01 00 00 00 00 00 00 00 00	Grünfutter	A3	2012-05-21 09:30:00+02	2012-05-21 09:30:00+02	\N	2016-03-07 11:04:15.14	\N	\N	\N	\N	2012-04-16 00:00:00	2012-06-17 21:59:59	2016-03-17 09:19:04.94469
+19	000007587671X	f	06010	06010	120614002	2	1	1	D: 01 25 02 25 00 00 00 00 02 00 00	Spargel, weiß	N24	2012-06-14 07:00:00+02	\N	\N	2012-06-19 09:31:23	\N	92	\N	\N	2012-06-01 00:00:00	2012-06-30 21:59:59	2016-03-17 09:19:04.94469
+707	000007613597X	f	11010	11010	125100012	2	1	1	D: 02 02 20 00 00 02 00 00 00 00 00	Silagen	F5Z	2012-01-11 10:00:00+01	2012-01-11 10:00:00+01	\N	2012-01-23 08:56:08	\N	\N	\N	\N	\N	\N	2016-03-17 09:19:04.94469
+158	000007575778X	f	11010	11010	125100007	2	1	1	D: 02 06 48 00 00 01 00 00 00 00 00	Nebenerzeugnisse trocken	F62	2012-01-27 10:15:00+01	2012-01-27 10:15:00+01	\N	2012-02-06 08:59:59	\N	\N	\N	\N	2012-01-01 00:00:00	2012-12-31 21:59:59	2016-03-17 09:19:04.94469
+155	000007575767X	f	11010	11010	125300001	2	1	1	D: 03 09 01 00 00 00 00 00 00 00 00	Pflanzliche Indikatoren	I13	2012-05-14 10:00:00+02	2012-05-14 10:00:00+02	\N	2012-05-30 12:04:35	\N	\N	\N	\N	2012-05-07 00:00:00	2012-09-30 21:59:59	2016-03-17 09:19:04.94469
+73	000007578295X	f	06060	06060	14360	2	1	1	D: 09 03 00 00 00 00 00 00 00 00 00	Kompostierung	A41	2012-05-10 10:00:00+02	\N	\N	2012-05-24 12:45:00	553	813	\N	\N	2012-05-07 00:00:00	2012-05-13 21:59:59	2016-03-17 09:19:04.94469
+71	000007578291X	f	06010	06010	120523008	2	1	1	D: 09 02 08 00 00 00 00 00 00 00 00	Deponie	A31	2012-05-11 10:30:00+02	\N	\N	2012-06-04 14:03:58	\N	813	\N	\N	2012-05-07 00:00:00	2012-05-13 21:59:59	2016-03-17 09:19:04.94469
+354	000007578191X	f	06010	06010	120110258	2	1	1	D: 01 10 55 00 00 00 00 00 00 00 00	Barschartige Fische Seefische Zuschnitte	N62	2012-01-10 09:00:00+01	\N	\N	2012-01-19 10:55:44	\N	734	\N	\N	2012-01-01 00:00:00	2012-01-31 21:59:59	2016-03-17 09:19:04.94469
+353	000007578188X	f	06010	06010	120117004	2	1	1	D: 01 06 23 00 05 02 02 00 00 00 00	Fleischteilstücke Lamm/Schaf auch tiefgefroren	N55	2012-01-17 10:00:00+01	\N	\N	2012-01-26 13:03:27	\N	734	\N	\N	2012-01-01 00:00:00	2012-06-30 21:59:59	2016-03-17 09:19:04.94469
+147	000007578141X	f	06060	06060	14242	2	1	1	D: 01 06 02 00 00 00 00 00 00 00 00	Fleischteilstücke Rind auch tiefgefroren	N51	2012-02-22 11:00:00+01	\N	\N	2012-02-29 14:45:58	553	714	\N	\N	2012-02-01 00:00:00	2012-02-29 21:59:59	2016-03-17 09:19:04.94469
+406	000007589328X	f	12020	12020	N0198FU12	2	1	1	D: 02 01 16 00 00 00 00 00 00 00 00	Grünfutter	F12	2012-06-07 09:00:00+02	\N	\N	2012-07-12 11:32:17	\N	1859	\N	\N	2012-04-01 00:00:00	2012-06-30 21:59:59	2016-03-17 09:19:04.94469
 \.
 
 
@@ -98,89 +98,89 @@
 
 ALTER TABLE messung DISABLE TRIGGER ALL;
 
-COPY messung (id, probe_id, nebenproben_nr, mmt_id, messdauer, messzeitpunkt, fertig, status, letzte_aenderung, geplant, tree_modified) FROM stdin;
-179	660	01G1	G1	82693	2012-01-30 09:32:00+01	t	571	2012-03-06 17:42:26	t	2016-03-17 09:19:04.94469
-198	409	01G1	G1	161733	2012-03-19 23:00:00+01	t	572	2012-04-17 19:42:25	t	2016-03-17 09:19:04.94469
-646	42	00G1	G1	60000	2012-01-09 14:48:00+01	f	573	2016-03-08 10:23:04.791	t	2016-03-17 09:19:04.94469
-699	313	G101	G1	247215	2012-02-24 11:00:00+01	t	574	2012-03-06 17:42:26	t	2016-03-17 09:19:04.94469
-697	311	G101	G1	90333	2012-06-13 11:00:00+02	t	575	2012-06-26 16:43:09	t	2016-03-17 09:19:04.94469
-765	112	BS01	BS	60000	2012-02-15 14:48:00+01	t	579	2012-02-22 15:42:21	t	2016-03-17 09:19:04.94469
-764	112	G101	G1	164945	2012-01-16 11:00:00+01	t	578	2012-01-25 11:42:08	t	2016-03-17 09:19:04.94469
-876	117	0001	G1	100000	2012-01-25 13:08:00+01	t	576	2012-02-03 16:45:22	t	2016-03-17 09:19:04.94469
-877	117	0002	BS	36000	2012-05-09 12:00:00+02	t	577	2012-08-16 10:44:27	t	2016-03-17 09:19:04.94469
-693	307	G101	G1	247808	2012-02-24 11:00:00+01	t	580	2012-03-06 17:42:26	t	2016-03-17 09:19:04.94469
-604	203	G101	G1	100732	2012-06-05 08:00:00+02	t	581	2012-06-11 15:45:32	t	2016-03-17 09:19:04.94469
-455	357	00G1	G1	60000	2012-01-12 14:24:00+01	t	582	2012-01-20 19:42:14	t	2016-03-17 09:19:04.94469
-677	292	G101	G1	330852	2012-01-27 12:00:00+01	t	583	2012-02-03 16:45:22	t	2016-03-17 09:19:04.94469
-679	294	G101	G1	245865	2012-01-27 12:00:00+01	t	584	2012-02-03 16:45:22	t	2016-03-17 09:19:04.94469
-907	25	00G1	G1	60000	2012-06-14 14:05:00+02	f	585	2016-03-08 16:46:57.46	t	2016-03-17 09:19:04.94469
-409	145	00G1	G1	60000	2012-04-25 13:10:00+02	t	586	2012-06-15 18:43:15	t	2016-03-17 09:19:04.94469
-45	4	00G1	G1	60000	2012-06-19 13:40:00+02	t	587	2012-06-26 15:42:31	t	2016-03-17 09:19:04.94469
-404	140	00G1	G1	60000	2012-01-05 14:35:00+01	t	588	2012-01-25 11:42:08	t	2016-03-17 09:19:04.94469
-669	284	G101	G1	105051	2012-06-05 07:00:00+02	t	589	2012-06-15 18:43:15	t	2016-03-17 09:19:04.94469
-382	703	00G1	G1	3600	2012-04-26 11:33:00+02	t	590	2012-05-07 11:45:47	t	2016-03-17 09:19:04.94469
-687	301	G101	G1	249270	2012-02-03 10:00:00+01	t	591	2012-02-16 16:42:24	t	2016-03-17 09:19:04.94469
-686	300	G101	G1	166714	2012-01-30 10:00:00+01	t	592	2012-02-03 16:45:22	t	2016-03-17 09:19:04.94469
-906	24	00G1	G1	60000	2012-06-19 13:33:00+02	t	593	2012-06-26 16:43:09	t	2016-03-17 09:19:04.94469
-682	296	G101	G1	158952	2012-05-07 12:00:00+02	t	594	2012-05-23 12:42:55	t	2016-03-17 09:19:04.94469
-749	99	G101	G1	421389	2012-01-11 10:00:00+01	t	595	2012-01-25 12:42:18	t	2016-03-17 09:19:04.94469
-855	194	BH01	BH	36000	2012-03-28 12:00:00+02	t	596	2012-04-16 14:42:18	t	2016-03-17 09:19:04.94469
-856	194	G101	G1	346327	2012-03-16 11:00:00+01	t	597	2012-03-26 11:42:27	t	2016-03-17 09:19:04.94469
-857	194	A101	A1	422783	2012-04-27 12:00:00+02	t	598	2012-05-14 13:42:57	t	2016-03-17 09:19:04.94469
-858	194	Bs01	BS	60000	2012-05-09 14:20:00+02	t	599	2012-05-30 12:42:36	t	2016-03-17 09:19:04.94469
-859	194	A102	A1	422795	2012-04-27 12:00:00+02	t	600	2012-05-14 13:42:57	f	2016-03-17 09:19:04.94469
-781	3	00G1	G1	60000	2012-05-29 12:59:00+02	t	601	2012-06-29 11:42:27	t	2016-03-17 09:19:04.94469
-782	3	0003	BS	36000	2012-06-15 10:00:00+02	t	602	2012-07-18 11:42:37	t	2016-03-17 09:19:04.94469
-783	3	00A1	A1	230005	2012-08-31 08:47:00+02	t	603	2012-10-02 10:42:49	t	2016-03-17 09:19:04.94469
-784	3	0004	BH	18000	2012-06-29 10:00:00+02	t	604	2012-07-18 11:42:37	t	2016-03-17 09:19:04.94469
-776	1	00A1	A1	230005	2012-08-31 08:44:00+02	t	605	2012-10-02 10:42:49	t	2016-03-17 09:19:04.94469
-777	1	00G1	G1	60000	2012-06-11 13:52:00+02	t	606	2012-06-29 11:42:27	t	2016-03-17 09:19:04.94469
-778	1	0004	BH	18000	2012-06-29 10:00:00+02	t	607	2012-07-18 11:42:37	t	2016-03-17 09:19:04.94469
-779	1	0003	BS	36000	2012-06-15 10:00:00+02	t	608	2012-07-18 11:42:37	t	2016-03-17 09:19:04.94469
-457	31	00G1	G1	60000	2012-03-01 15:33:00+01	t	609	2012-03-15 14:42:18	t	2016-03-17 09:19:04.94469
-546	84	00G1	G1	60000	2012-04-17 13:21:00+02	t	610	2012-06-29 13:42:59	t	2016-03-17 09:19:04.94469
-547	84	0003	BS	36000	2012-11-13 11:00:00+01	t	611	2013-02-22 11:42:23	t	2016-03-17 09:19:04.94469
-536	76	00G1	G1	60000	2012-03-30 12:20:00+02	t	612	2012-04-20 17:42:12	t	2016-03-17 09:19:04.94469
-552	88	0003	BS	36000	2012-10-25 10:00:00+02	t	613	2012-11-09 17:42:48	t	2016-03-17 09:19:04.94469
-553	88	00G1	G1	60000	2012-03-30 12:15:00+02	t	614	2012-04-20 17:42:12	t	2016-03-17 09:19:04.94469
-841	180	G101	G1	246610	2012-03-16 11:00:00+01	t	615	2012-03-27 13:42:09	t	2016-03-17 09:19:04.94469
-574	97	00G1	G1	60000	2012-03-07 14:12:00+01	t	616	2012-03-27 13:42:09	t	2016-03-17 09:19:04.94469
-558	91	0003	BH	18000	2012-03-12 21:40:00+01	t	617	2012-07-27 11:42:24	t	2016-03-17 09:19:04.94469
-559	91	0001	G1	150000	2012-02-29 16:36:00+01	t	618	2012-03-06 12:42:22	t	2016-03-17 09:19:04.94469
-847	186	G101	G1	244982	2012-03-09 12:00:00+01	t	619	2012-03-12 11:42:52	t	2016-03-17 09:19:04.94469
-835	174	G101	G1	264401	2012-03-13 09:00:00+01	t	620	2012-03-27 13:42:09	t	2016-03-17 09:19:04.94469
-792	160	BS01	BS	60000	2012-05-14 13:50:00+02	t	621	2012-05-22 15:42:28	t	2016-03-17 09:19:04.94469
-793	160	BH01	BH	36000	2012-03-27 12:00:00+02	t	622	2012-04-18 17:42:24	t	2016-03-17 09:19:04.94469
-794	160	G101	G1	136410	2012-03-20 12:00:00+01	t	623	2012-03-27 13:42:09	t	2016-03-17 09:19:04.94469
-795	160	A101	A1	416061	2012-05-02 12:00:00+02	t	624	2012-05-11 19:42:33	t	2016-03-17 09:19:04.94469
-796	160	A102	A1	338466	2012-05-03 12:00:00+02	t	625	2012-05-11 19:42:33	f	2016-03-17 09:19:04.94469
-593	200	BH01	BH	36000	2012-07-05 12:00:00+02	t	626	2012-07-27 11:42:24	t	2016-03-17 09:19:04.94469
-594	200	A101	A1	344683	2012-06-01 12:00:00+02	t	627	2012-06-12 11:46:00	t	2016-03-17 09:19:04.94469
-595	200	BS01	BS	1000	2012-07-10 12:40:00+02	t	628	2012-07-27 11:42:24	t	2016-03-17 09:19:04.94469
-596	200	G101	G1	696089	2012-05-15 10:00:00+02	t	629	2012-06-12 11:46:00	t	2016-03-17 09:19:04.94469
-597	200	A102	A1	436113	2012-05-31 12:00:00+02	t	630	2012-06-12 11:46:00	f	2016-03-17 09:19:04.94469
-649	45	00G1	G1	60000	2012-01-26 14:26:00+01	t	631	2012-03-12 09:12:13	t	2016-03-17 09:19:04.94469
-499	55	00G1	G1	60000	2012-02-01 13:54:00+01	t	632	2012-03-15 13:42:20	t	2016-03-17 09:19:04.94469
-517	69	00G1	G1	60000	2012-03-13 14:19:00+01	t	633	2012-03-26 11:42:27	t	2016-03-17 09:19:04.94469
-515	67	00G1	G1	60000	2012-03-13 14:17:00+01	t	634	2012-03-26 11:42:27	t	2016-03-17 09:19:04.94469
-518	70	00G1	G1	60000	2012-03-14 14:41:00+01	t	635	2012-03-26 11:42:27	t	2016-03-17 09:19:04.94469
-513	65	00G1	G1	60000	2012-03-13 14:24:00+01	t	636	2012-03-26 11:42:27	t	2016-03-17 09:19:04.94469
-538	78	00G1	G1	60000	2012-04-04 14:01:00+02	t	637	2012-05-07 18:42:50	t	2016-03-17 09:19:04.94469
-539	78	0003	BS	36000	2012-06-21 10:00:00+02	t	638	2012-07-12 17:42:35	t	2016-03-17 09:19:04.94469
-639	36	0003	BS	36000	2012-09-10 10:00:00+02	t	639	2013-02-22 11:42:23	t	2016-03-17 09:19:04.94469
-640	36	00G1	G1	60000	2012-05-02 13:44:00+02	t	640	2012-09-18 12:41:00	t	2016-03-17 09:19:04.94469
-788	157	G101	G1	445822	2012-05-24 09:00:00+02	t	645	2012-06-07 18:42:19	t	2016-03-17 09:19:04.94469
-901	19	00G1	G1	60000	2012-06-14 14:03:00+02	t	641	2012-06-26 15:42:31	t	2016-03-17 09:19:04.94469
-900	707	G101	G1	419333	2012-01-18 11:00:00+01	t	642	2012-01-24 19:42:23	f	2016-03-17 09:19:04.94469
-789	158	G101	G1	425991	2012-02-01 09:00:00+01	t	643	2012-02-16 19:42:18	t	2016-03-17 09:19:04.94469
-785	155	G101	G1	345463	2012-05-18 06:00:00+02	t	646	2012-06-05 17:42:20	t	2016-03-17 09:19:04.94469
-533	73	0001	G1	100000	2012-05-22 11:12:00+02	t	647	2012-05-30 12:42:35	t	2016-03-17 09:19:04.94469
-529	71	0004	BH	18000	2012-06-30 10:00:00+02	t	648	2012-07-18 11:42:37	t	2016-03-17 09:19:04.94469
-530	71	00G1	G1	60000	2012-05-31 13:32:00+02	t	649	2012-06-29 13:42:59	t	2016-03-17 09:19:04.94469
-452	354	00G1	G1	60000	2012-01-12 14:22:00+01	t	650	2012-01-20 19:42:14	t	2016-03-17 09:19:04.94469
-451	353	00G1	G1	60000	2012-01-18 15:20:00+01	t	651	2012-02-03 16:45:22	t	2016-03-17 09:19:04.94469
-411	147	0001	G1	50000	2012-02-28 12:38:00+01	t	653	2012-03-06 17:42:26	t	2016-03-17 09:19:04.94469
-195	406	01G1	G1	85198	2012-06-11 13:06:00+02	t	654	2012-07-17 15:42:25	t	2016-03-17 09:19:04.94469
+COPY messung (id, id_alt, probe_id, nebenproben_nr, mmt_id, messdauer, messzeitpunkt, fertig, status, letzte_aenderung, geplant, tree_modified) FROM stdin;
+179	1	660	01G1	G1	82693	2012-01-30 09:32:00+01	t	571	2012-03-06 17:42:26	t	2016-03-17 09:19:04.94469
+198	1	409	01G1	G1	161733	2012-03-19 23:00:00+01	t	572	2012-04-17 19:42:25	t	2016-03-17 09:19:04.94469
+646	1	42	00G1	G1	60000	2012-01-09 14:48:00+01	f	573	2016-03-08 10:23:04.791	t	2016-03-17 09:19:04.94469
+699	1	313	G101	G1	247215	2012-02-24 11:00:00+01	t	574	2012-03-06 17:42:26	t	2016-03-17 09:19:04.94469
+697	1	311	G101	G1	90333	2012-06-13 11:00:00+02	t	575	2012-06-26 16:43:09	t	2016-03-17 09:19:04.94469
+765	2	112	BS01	BS	60000	2012-02-15 14:48:00+01	t	579	2012-02-22 15:42:21	t	2016-03-17 09:19:04.94469
+764	1	112	G101	G1	164945	2012-01-16 11:00:00+01	t	578	2012-01-25 11:42:08	t	2016-03-17 09:19:04.94469
+876	1	117	0001	G1	100000	2012-01-25 13:08:00+01	t	576	2012-02-03 16:45:22	t	2016-03-17 09:19:04.94469
+877	2	117	0002	BS	36000	2012-05-09 12:00:00+02	t	577	2012-08-16 10:44:27	t	2016-03-17 09:19:04.94469
+693	1	307	G101	G1	247808	2012-02-24 11:00:00+01	t	580	2012-03-06 17:42:26	t	2016-03-17 09:19:04.94469
+604	1	203	G101	G1	100732	2012-06-05 08:00:00+02	t	581	2012-06-11 15:45:32	t	2016-03-17 09:19:04.94469
+455	1	357	00G1	G1	60000	2012-01-12 14:24:00+01	t	582	2012-01-20 19:42:14	t	2016-03-17 09:19:04.94469
+677	1	292	G101	G1	330852	2012-01-27 12:00:00+01	t	583	2012-02-03 16:45:22	t	2016-03-17 09:19:04.94469
+679	1	294	G101	G1	245865	2012-01-27 12:00:00+01	t	584	2012-02-03 16:45:22	t	2016-03-17 09:19:04.94469
+907	1	25	00G1	G1	60000	2012-06-14 14:05:00+02	f	585	2016-03-08 16:46:57.46	t	2016-03-17 09:19:04.94469
+409	1	145	00G1	G1	60000	2012-04-25 13:10:00+02	t	586	2012-06-15 18:43:15	t	2016-03-17 09:19:04.94469
+45	1	4	00G1	G1	60000	2012-06-19 13:40:00+02	t	587	2012-06-26 15:42:31	t	2016-03-17 09:19:04.94469
+404	1	140	00G1	G1	60000	2012-01-05 14:35:00+01	t	588	2012-01-25 11:42:08	t	2016-03-17 09:19:04.94469
+669	1	284	G101	G1	105051	2012-06-05 07:00:00+02	t	589	2012-06-15 18:43:15	t	2016-03-17 09:19:04.94469
+382	1	703	00G1	G1	3600	2012-04-26 11:33:00+02	t	590	2012-05-07 11:45:47	t	2016-03-17 09:19:04.94469
+687	1	301	G101	G1	249270	2012-02-03 10:00:00+01	t	591	2012-02-16 16:42:24	t	2016-03-17 09:19:04.94469
+686	1	300	G101	G1	166714	2012-01-30 10:00:00+01	t	592	2012-02-03 16:45:22	t	2016-03-17 09:19:04.94469
+906	1	24	00G1	G1	60000	2012-06-19 13:33:00+02	t	593	2012-06-26 16:43:09	t	2016-03-17 09:19:04.94469
+682	1	296	G101	G1	158952	2012-05-07 12:00:00+02	t	594	2012-05-23 12:42:55	t	2016-03-17 09:19:04.94469
+749	1	99	G101	G1	421389	2012-01-11 10:00:00+01	t	595	2012-01-25 12:42:18	t	2016-03-17 09:19:04.94469
+855	1	194	BH01	BH	36000	2012-03-28 12:00:00+02	t	596	2012-04-16 14:42:18	t	2016-03-17 09:19:04.94469
+856	4	194	G101	G1	346327	2012-03-16 11:00:00+01	t	597	2012-03-26 11:42:27	t	2016-03-17 09:19:04.94469
+857	2	194	A101	A1	422783	2012-04-27 12:00:00+02	t	598	2012-05-14 13:42:57	t	2016-03-17 09:19:04.94469
+858	3	194	Bs01	BS	60000	2012-05-09 14:20:00+02	t	599	2012-05-30 12:42:36	t	2016-03-17 09:19:04.94469
+859	5	194	A102	A1	422795	2012-04-27 12:00:00+02	t	600	2012-05-14 13:42:57	f	2016-03-17 09:19:04.94469
+781	3	3	00G1	G1	60000	2012-05-29 12:59:00+02	t	601	2012-06-29 11:42:27	t	2016-03-17 09:19:04.94469
+782	1	3	0003	BS	36000	2012-06-15 10:00:00+02	t	602	2012-07-18 11:42:37	t	2016-03-17 09:19:04.94469
+783	4	3	00A1	A1	230005	2012-08-31 08:47:00+02	t	603	2012-10-02 10:42:49	t	2016-03-17 09:19:04.94469
+784	2	3	0004	BH	18000	2012-06-29 10:00:00+02	t	604	2012-07-18 11:42:37	t	2016-03-17 09:19:04.94469
+776	1	1	00A1	A1	230005	2012-08-31 08:44:00+02	t	605	2012-10-02 10:42:49	t	2016-03-17 09:19:04.94469
+777	2	1	00G1	G1	60000	2012-06-11 13:52:00+02	t	606	2012-06-29 11:42:27	t	2016-03-17 09:19:04.94469
+778	4	1	0004	BH	18000	2012-06-29 10:00:00+02	t	607	2012-07-18 11:42:37	t	2016-03-17 09:19:04.94469
+779	3	1	0003	BS	36000	2012-06-15 10:00:00+02	t	608	2012-07-18 11:42:37	t	2016-03-17 09:19:04.94469
+457	1	31	00G1	G1	60000	2012-03-01 15:33:00+01	t	609	2012-03-15 14:42:18	t	2016-03-17 09:19:04.94469
+546	2	84	00G1	G1	60000	2012-04-17 13:21:00+02	t	610	2012-06-29 13:42:59	t	2016-03-17 09:19:04.94469
+547	1	84	0003	BS	36000	2012-11-13 11:00:00+01	t	611	2013-02-22 11:42:23	t	2016-03-17 09:19:04.94469
+536	1	76	00G1	G1	60000	2012-03-30 12:20:00+02	t	612	2012-04-20 17:42:12	t	2016-03-17 09:19:04.94469
+552	1	88	0003	BS	36000	2012-10-25 10:00:00+02	t	613	2012-11-09 17:42:48	t	2016-03-17 09:19:04.94469
+553	2	88	00G1	G1	60000	2012-03-30 12:15:00+02	t	614	2012-04-20 17:42:12	t	2016-03-17 09:19:04.94469
+841	1	180	G101	G1	246610	2012-03-16 11:00:00+01	t	615	2012-03-27 13:42:09	t	2016-03-17 09:19:04.94469
+574	1	97	00G1	G1	60000	2012-03-07 14:12:00+01	t	616	2012-03-27 13:42:09	t	2016-03-17 09:19:04.94469
+558	2	91	0003	BH	18000	2012-03-12 21:40:00+01	t	617	2012-07-27 11:42:24	t	2016-03-17 09:19:04.94469
+559	1	91	0001	G1	150000	2012-02-29 16:36:00+01	t	618	2012-03-06 12:42:22	t	2016-03-17 09:19:04.94469
+847	1	186	G101	G1	244982	2012-03-09 12:00:00+01	t	619	2012-03-12 11:42:52	t	2016-03-17 09:19:04.94469
+835	1	174	G101	G1	264401	2012-03-13 09:00:00+01	t	620	2012-03-27 13:42:09	t	2016-03-17 09:19:04.94469
+792	1	160	BS01	BS	60000	2012-05-14 13:50:00+02	t	621	2012-05-22 15:42:28	t	2016-03-17 09:19:04.94469
+793	4	160	BH01	BH	36000	2012-03-27 12:00:00+02	t	622	2012-04-18 17:42:24	t	2016-03-17 09:19:04.94469
+794	3	160	G101	G1	136410	2012-03-20 12:00:00+01	t	623	2012-03-27 13:42:09	t	2016-03-17 09:19:04.94469
+795	2	160	A101	A1	416061	2012-05-02 12:00:00+02	t	624	2012-05-11 19:42:33	t	2016-03-17 09:19:04.94469
+796	5	160	A102	A1	338466	2012-05-03 12:00:00+02	t	625	2012-05-11 19:42:33	f	2016-03-17 09:19:04.94469
+593	1	200	BH01	BH	36000	2012-07-05 12:00:00+02	t	626	2012-07-27 11:42:24	t	2016-03-17 09:19:04.94469
+594	3	200	A101	A1	344683	2012-06-01 12:00:00+02	t	627	2012-06-12 11:46:00	t	2016-03-17 09:19:04.94469
+595	4	200	BS01	BS	1000	2012-07-10 12:40:00+02	t	628	2012-07-27 11:42:24	t	2016-03-17 09:19:04.94469
+596	2	200	G101	G1	696089	2012-05-15 10:00:00+02	t	629	2012-06-12 11:46:00	t	2016-03-17 09:19:04.94469
+597	5	200	A102	A1	436113	2012-05-31 12:00:00+02	t	630	2012-06-12 11:46:00	f	2016-03-17 09:19:04.94469
+649	1	45	00G1	G1	60000	2012-01-26 14:26:00+01	t	631	2012-03-12 09:12:13	t	2016-03-17 09:19:04.94469
+499	1	55	00G1	G1	60000	2012-02-01 13:54:00+01	t	632	2012-03-15 13:42:20	t	2016-03-17 09:19:04.94469
+517	1	69	00G1	G1	60000	2012-03-13 14:19:00+01	t	633	2012-03-26 11:42:27	t	2016-03-17 09:19:04.94469
+515	1	67	00G1	G1	60000	2012-03-13 14:17:00+01	t	634	2012-03-26 11:42:27	t	2016-03-17 09:19:04.94469
+518	1	70	00G1	G1	60000	2012-03-14 14:41:00+01	t	635	2012-03-26 11:42:27	t	2016-03-17 09:19:04.94469
+513	1	65	00G1	G1	60000	2012-03-13 14:24:00+01	t	636	2012-03-26 11:42:27	t	2016-03-17 09:19:04.94469
+538	2	78	00G1	G1	60000	2012-04-04 14:01:00+02	t	637	2012-05-07 18:42:50	t	2016-03-17 09:19:04.94469
+539	1	78	0003	BS	36000	2012-06-21 10:00:00+02	t	638	2012-07-12 17:42:35	t	2016-03-17 09:19:04.94469
+639	2	36	0003	BS	36000	2012-09-10 10:00:00+02	t	639	2013-02-22 11:42:23	t	2016-03-17 09:19:04.94469
+640	1	36	00G1	G1	60000	2012-05-02 13:44:00+02	t	640	2012-09-18 12:41:00	t	2016-03-17 09:19:04.94469
+788	1	157	G101	G1	445822	2012-05-24 09:00:00+02	t	645	2012-06-07 18:42:19	t	2016-03-17 09:19:04.94469
+901	1	19	00G1	G1	60000	2012-06-14 14:03:00+02	t	641	2012-06-26 15:42:31	t	2016-03-17 09:19:04.94469
+900	1	707	G101	G1	419333	2012-01-18 11:00:00+01	t	642	2012-01-24 19:42:23	f	2016-03-17 09:19:04.94469
+789	1	158	G101	G1	425991	2012-02-01 09:00:00+01	t	643	2012-02-16 19:42:18	t	2016-03-17 09:19:04.94469
+785	1	155	G101	G1	345463	2012-05-18 06:00:00+02	t	646	2012-06-05 17:42:20	t	2016-03-17 09:19:04.94469
+533	1	73	0001	G1	100000	2012-05-22 11:12:00+02	t	647	2012-05-30 12:42:35	t	2016-03-17 09:19:04.94469
+529	1	71	0004	BH	18000	2012-06-30 10:00:00+02	t	648	2012-07-18 11:42:37	t	2016-03-17 09:19:04.94469
+530	2	71	00G1	G1	60000	2012-05-31 13:32:00+02	t	649	2012-06-29 13:42:59	t	2016-03-17 09:19:04.94469
+452	1	354	00G1	G1	60000	2012-01-12 14:22:00+01	t	650	2012-01-20 19:42:14	t	2016-03-17 09:19:04.94469
+451	1	353	00G1	G1	60000	2012-01-18 15:20:00+01	t	651	2012-02-03 16:45:22	t	2016-03-17 09:19:04.94469
+411	1	147	0001	G1	50000	2012-02-28 12:38:00+01	t	653	2012-03-06 17:42:26	t	2016-03-17 09:19:04.94469
+195	1	406	01G1	G1	85198	2012-06-11 13:06:00+02	t	654	2012-07-17 15:42:25	t	2016-03-17 09:19:04.94469
 \.
 
 
@@ -194,7 +194,7 @@
 
 ALTER TABLE kommentar_m DISABLE TRIGGER ALL;
 
-COPY kommentar_m (id, erzeuger, datum, text, messungs_id) FROM stdin;
+COPY kommentar_m (id, mst_id, datum, text, messungs_id) FROM stdin;
 481	12020	2012-07-12 06:18:00	Messung FM\nFM/TM lt Stammdaten	195
 482	12020	2012-07-12 09:32:00	Messung FM\nFM/TM lt Stammdaten	195
 \.
@@ -210,7 +210,7 @@
 
 ALTER TABLE kommentar_p DISABLE TRIGGER ALL;
 
-COPY kommentar_p (id, erzeuger, datum, text, probe_id) FROM stdin;
+COPY kommentar_p (id, mst_id, datum, text, probe_id) FROM stdin;
 120	12020	2011-12-14 12:43:38	n_im04	660
 168	06010	2011-11-07 12:10:49	A76, A0-Horizont: Probenahmetiefe (Mächtigkeit der Humusschicht) notieren!	84
 183	12020	2011-12-14 12:30:49	n_pf07	406
@@ -234,7 +234,7 @@
 
 ALTER TABLE messprogramm DISABLE TRIGGER ALL;
 
-COPY messprogramm (id, name, test, netzbetreiber_id, mst_id, labor_mst_id, datenbasis_id, ba_id, gem_id, ort_id, media_desk, umw_id, probenart_id, probenintervall, teilintervall_von, teilintervall_bis, intervall_offset, gueltig_von, gueltig_bis, probe_nehmer_id, probe_kommentar, letzte_aenderung) FROM stdin;
+COPY messprogramm (id, test, mst_id, labor_mst_id, datenbasis_id, ba_id, gem_id, ort_id, media_desk, umw_id, probenart_id, probenintervall, teilintervall_von, teilintervall_bis, intervall_offset, gueltig_von, gueltig_bis, probe_nehmer_id, probe_kommentar, letzte_aenderung) FROM stdin;
 \.
 
 
@@ -271,112 +271,6 @@
 
 SELECT pg_catalog.setval('messprogramm_mmt_id_seq', 1, false);
 
-
---
--- TOC entry 4688 (class 0 OID 1170831)
--- Dependencies: 290
--- Data for Name: messung_translation; Type: TABLE DATA; Schema: land; Owner: postgres
---
-
-ALTER TABLE messung_translation DISABLE TRIGGER ALL;
-
-COPY messung_translation (id, messungs_id, messungs_id_alt) FROM stdin;
-45	45	1
-179	179	1
-195	195	1
-198	198	1
-382	382	1
-404	404	1
-409	409	1
-411	411	1
-451	451	1
-452	452	1
-455	455	1
-457	457	1
-499	499	1
-513	513	1
-515	515	1
-517	517	1
-518	518	1
-529	529	1
-530	530	2
-533	533	1
-536	536	1
-538	538	2
-539	539	1
-546	546	2
-547	547	1
-552	552	1
-553	553	2
-558	558	2
-559	559	1
-574	574	1
-593	593	1
-594	594	3
-595	595	4
-596	596	2
-597	597	5
-604	604	1
-639	639	2
-640	640	1
-646	646	1
-649	649	1
-669	669	1
-677	677	1
-679	679	1
-682	682	1
-686	686	1
-687	687	1
-693	693	1
-697	697	1
-699	699	1
-749	749	1
-764	764	1
-765	765	2
-776	776	1
-777	777	2
-778	778	4
-779	779	3
-781	781	3
-782	782	1
-783	783	4
-784	784	2
-785	785	1
-788	788	1
-789	789	1
-792	792	1
-793	793	4
-794	794	3
-795	795	2
-796	796	5
-835	835	1
-841	841	1
-847	847	1
-855	855	1
-856	856	4
-857	857	2
-858	858	3
-859	859	5
-876	876	1
-877	877	2
-900	900	1
-901	901	1
-906	906	1
-907	907	1
-\.
-
-
-ALTER TABLE messung_translation ENABLE TRIGGER ALL;
-
---
--- TOC entry 4703 (class 0 OID 0)
--- Dependencies: 291
--- Name: messung_translation_id_seq; Type: SEQUENCE SET; Schema: land; Owner: postgres
---
-
-SELECT pg_catalog.setval('messung_translation_id_seq', 1009, true);
-
-
 --
 -- TOC entry 4690 (class 0 OID 1170837)
 -- Dependencies: 292
@@ -998,85 +892,6 @@
 ALTER TABLE ortszuordnung ENABLE TRIGGER ALL;
 
 --
--- TOC entry 4693 (class 0 OID 1170889)
--- Dependencies: 295
--- Data for Name: probe_translation; Type: TABLE DATA; Schema: land; Owner: postgres
---
-
-ALTER TABLE probe_translation DISABLE TRIGGER ALL;
-
-COPY probe_translation (id, probe_id, probe_id_alt) FROM stdin;
-1	1	000007581034X
-3	3	000007581040X
-4	4	000007587554X
-19	19	000007587671X
-24	24	000007587691X
-25	25	000007587696X
-31	31	000007578204X
-36	36	000007578214X
-42	42	000007578227X
-45	45	000007578239X
-55	55	000007578259X
-65	65	000007578279X
-67	67	000007578283X
-69	69	000007578287X
-70	70	000007578289X
-71	71	000007578291X
-73	73	000007578295X
-76	76	000007578301X
-78	78	000007578303X
-84	84	000007578312X
-88	88	000007578316X
-91	91	000007578319X
-97	97	000007578331X
-99	99	000007575726X
-112	112	000007575752X
-117	117	000007578031X
-140	140	000007578082X
-145	145	000007578087X
-147	147	000007578141X
-155	155	000007575767X
-157	157	000007575772X
-159	158	000007575778X
-161	160	000007575783X
-175	174	000007575807X
-181	180	000007575819X
-187	186	000007575831X
-195	194	000007575847X
-201	200	000007575856X
-204	203	000007575864X
-284	284	000007575917X
-292	292	000007575939X
-294	294	000007575941X
-296	296	000007575943X
-300	300	000007575949X
-301	301	000007575950X
-307	307	000007575960X
-311	311	000007575967X
-313	313	000007575969X
-353	353	000007578188X
-354	354	000007578191X
-357	357	000007578195X
-407	406	000007589328X
-410	409	000007589343X
-660	660	000007590041X
-703	703	000007590316X
-707	707	000007613597X
-\.
-
-
-ALTER TABLE probe_translation ENABLE TRIGGER ALL;
-
---
--- TOC entry 4704 (class 0 OID 0)
--- Dependencies: 296
--- Name: probe_translation_id_seq; Type: SEQUENCE SET; Schema: land; Owner: postgres
---
-
-SELECT pg_catalog.setval('probe_translation_id_seq', 733, true);
-
-
---
 -- TOC entry 4695 (class 0 OID 1170895)
 -- Dependencies: 297
 -- Data for Name: status_protokoll; Type: TABLE DATA; Schema: land; Owner: postgres
@@ -1084,89 +899,89 @@
 
 ALTER TABLE status_protokoll DISABLE TRIGGER ALL;
 
-COPY status_protokoll (id, erzeuger, datum, text, messungs_id, status_stufe, status_wert, tree_modified) FROM stdin;
-571	12020	2016-02-29 21:53:01.736444	Test	179	1	0	2016-03-17 09:19:04.94469
-572	12010	2016-02-29 21:53:01.736444	Test	198	1	0	2016-03-17 09:19:04.94469
-573	06010	2016-02-29 21:53:01.736444	Test	646	1	0	2016-03-17 09:19:04.94469
-574	11010	2016-02-29 21:53:01.736444	Test	699	1	0	2016-03-17 09:19:04.94469
-575	11010	2016-02-29 21:53:01.736444	Test	697	1	0	2016-03-17 09:19:04.94469
-579	11010	2016-02-29 21:53:01.736444	Test	765	1	0	2016-03-17 09:19:04.94469
-578	11010	2016-02-29 21:53:01.736444	Test	764	1	0	2016-03-17 09:19:04.94469
-576	06060	2016-02-29 21:53:01.736444	Test	876	1	0	2016-03-17 09:19:04.94469
-577	06060	2016-02-29 21:53:01.736444	Test	877	1	0	2016-03-17 09:19:04.94469
-580	11010	2016-02-29 21:53:01.736444	Test	693	1	0	2016-03-17 09:19:04.94469
-581	11010	2016-02-29 21:53:01.736444	Test	604	1	0	2016-03-17 09:19:04.94469
-582	06010	2016-02-29 21:53:01.736444	Test	455	1	0	2016-03-17 09:19:04.94469
-583	11010	2016-02-29 21:53:01.736444	Test	677	1	0	2016-03-17 09:19:04.94469
-584	11010	2016-02-29 21:53:01.736444	Test	679	1	0	2016-03-17 09:19:04.94469
-585	06010	2016-02-29 21:53:01.736444	Test	907	1	0	2016-03-17 09:19:04.94469
-586	06010	2016-02-29 21:53:01.736444	Test	409	1	0	2016-03-17 09:19:04.94469
-587	06010	2016-02-29 21:53:01.736444	Test	45	1	0	2016-03-17 09:19:04.94469
-588	06010	2016-02-29 21:53:01.736444	Test	404	1	0	2016-03-17 09:19:04.94469
-589	11010	2016-02-29 21:53:01.736444	Test	669	1	0	2016-03-17 09:19:04.94469
-590	06010	2016-02-29 21:53:01.736444	Test	382	1	0	2016-03-17 09:19:04.94469
-591	11010	2016-02-29 21:53:01.736444	Test	687	1	0	2016-03-17 09:19:04.94469
-592	11010	2016-02-29 21:53:01.736444	Test	686	1	0	2016-03-17 09:19:04.94469
-593	06010	2016-02-29 21:53:01.736444	Test	906	1	0	2016-03-17 09:19:04.94469
-594	11010	2016-02-29 21:53:01.736444	Test	682	1	0	2016-03-17 09:19:04.94469
-595	11010	2016-02-29 21:53:01.736444	Test	749	1	0	2016-03-17 09:19:04.94469
-596	11010	2016-02-29 21:53:01.736444	Test	855	1	0	2016-03-17 09:19:04.94469
-597	11010	2016-02-29 21:53:01.736444	Test	856	1	0	2016-03-17 09:19:04.94469
-598	11010	2016-02-29 21:53:01.736444	Test	857	1	0	2016-03-17 09:19:04.94469
-599	11010	2016-02-29 21:53:01.736444	Test	858	1	0	2016-03-17 09:19:04.94469
-600	11010	2016-02-29 21:53:01.736444	Test	859	1	0	2016-03-17 09:19:04.94469
-601	06010	2016-02-29 21:53:01.736444	Test	781	1	0	2016-03-17 09:19:04.94469
-602	06010	2016-02-29 21:53:01.736444	Test	782	1	0	2016-03-17 09:19:04.94469
-603	06010	2016-02-29 21:53:01.736444	Test	783	1	0	2016-03-17 09:19:04.94469
-604	06010	2016-02-29 21:53:01.736444	Test	784	1	0	2016-03-17 09:19:04.94469
-605	06010	2016-02-29 21:53:01.736444	Test	776	1	0	2016-03-17 09:19:04.94469
-606	06010	2016-02-29 21:53:01.736444	Test	777	1	0	2016-03-17 09:19:04.94469
-607	06010	2016-02-29 21:53:01.736444	Test	778	1	0	2016-03-17 09:19:04.94469
-608	06010	2016-02-29 21:53:01.736444	Test	779	1	0	2016-03-17 09:19:04.94469
-609	06010	2016-02-29 21:53:01.736444	Test	457	1	0	2016-03-17 09:19:04.94469
-610	06010	2016-02-29 21:53:01.736444	Test	546	1	0	2016-03-17 09:19:04.94469
-611	06010	2016-02-29 21:53:01.736444	Test	547	1	0	2016-03-17 09:19:04.94469
-612	06010	2016-02-29 21:53:01.736444	Test	536	1	0	2016-03-17 09:19:04.94469
-613	06010	2016-02-29 21:53:01.736444	Test	552	1	0	2016-03-17 09:19:04.94469
-614	06010	2016-02-29 21:53:01.736444	Test	553	1	0	2016-03-17 09:19:04.94469
-615	11010	2016-02-29 21:53:01.736444	Test	841	1	0	2016-03-17 09:19:04.94469
-616	06010	2016-02-29 21:53:01.736444	Test	574	1	0	2016-03-17 09:19:04.94469
-617	06060	2016-02-29 21:53:01.736444	Test	558	1	0	2016-03-17 09:19:04.94469
-618	06060	2016-02-29 21:53:01.736444	Test	559	1	0	2016-03-17 09:19:04.94469
-619	11010	2016-02-29 21:53:01.736444	Test	847	1	0	2016-03-17 09:19:04.94469
-620	11010	2016-02-29 21:53:01.736444	Test	835	1	0	2016-03-17 09:19:04.94469
-621	11010	2016-02-29 21:53:01.736444	Test	792	1	0	2016-03-17 09:19:04.94469
-622	11010	2016-02-29 21:53:01.736444	Test	793	1	0	2016-03-17 09:19:04.94469
-623	11010	2016-02-29 21:53:01.736444	Test	794	1	0	2016-03-17 09:19:04.94469
-624	11010	2016-02-29 21:53:01.736444	Test	795	1	0	2016-03-17 09:19:04.94469
-625	11010	2016-02-29 21:53:01.736444	Test	796	1	0	2016-03-17 09:19:04.94469
-626	11010	2016-02-29 21:53:01.736444	Test	593	1	0	2016-03-17 09:19:04.94469
-627	11010	2016-02-29 21:53:01.736444	Test	594	1	0	2016-03-17 09:19:04.94469
-628	11010	2016-02-29 21:53:01.736444	Test	595	1	0	2016-03-17 09:19:04.94469
-629	11010	2016-02-29 21:53:01.736444	Test	596	1	0	2016-03-17 09:19:04.94469
-630	11010	2016-02-29 21:53:01.736444	Test	597	1	0	2016-03-17 09:19:04.94469
-631	06010	2016-02-29 21:53:01.736444	Test	649	1	0	2016-03-17 09:19:04.94469
-632	06010	2016-02-29 21:53:01.736444	Test	499	1	0	2016-03-17 09:19:04.94469
-633	06010	2016-02-29 21:53:01.736444	Test	517	1	0	2016-03-17 09:19:04.94469
-634	06010	2016-02-29 21:53:01.736444	Test	515	1	0	2016-03-17 09:19:04.94469
-635	06010	2016-02-29 21:53:01.736444	Test	518	1	0	2016-03-17 09:19:04.94469
-636	06010	2016-02-29 21:53:01.736444	Test	513	1	0	2016-03-17 09:19:04.94469
-637	06010	2016-02-29 21:53:01.736444	Test	538	1	0	2016-03-17 09:19:04.94469
-638	06010	2016-02-29 21:53:01.736444	Test	539	1	0	2016-03-17 09:19:04.94469
-639	06010	2016-02-29 21:53:01.736444	Test	639	1	0	2016-03-17 09:19:04.94469
-640	06010	2016-02-29 21:53:01.736444	Test	640	1	0	2016-03-17 09:19:04.94469
-645	11010	2016-02-29 21:53:01.736444	Test	788	1	0	2016-03-17 09:19:04.94469
-641	06010	2016-02-29 21:53:01.736444	Test	901	1	0	2016-03-17 09:19:04.94469
-642	11010	2016-02-29 21:53:01.736444	Test	900	1	0	2016-03-17 09:19:04.94469
-643	11010	2016-02-29 21:53:01.736444	Test	789	1	0	2016-03-17 09:19:04.94469
-646	11010	2016-02-29 21:53:01.736444	Test	785	1	0	2016-03-17 09:19:04.94469
-647	06060	2016-02-29 21:53:01.736444	Test	533	1	0	2016-03-17 09:19:04.94469
-648	06010	2016-02-29 21:53:01.736444	Test	529	1	0	2016-03-17 09:19:04.94469
-649	06010	2016-02-29 21:53:01.736444	Test	530	1	0	2016-03-17 09:19:04.94469
-650	06010	2016-02-29 21:53:01.736444	Test	452	1	0	2016-03-17 09:19:04.94469
-651	06010	2016-02-29 21:53:01.736444	Test	451	1	0	2016-03-17 09:19:04.94469
-653	06060	2016-02-29 21:53:01.736444	Test	411	1	0	2016-03-17 09:19:04.94469
-654	12020	2016-02-29 21:53:01.736444	Test	195	1	0	2016-03-17 09:19:04.94469
+COPY status_protokoll (id, mst_id, datum, text, messungs_id, status_kombi, tree_modified) FROM stdin;
+571	12020	2016-02-29 21:53:01.736444	Test	179	1	2016-03-17 09:19:04.94469
+572	12010	2016-02-29 21:53:01.736444	Test	198	1	2016-03-17 09:19:04.94469
+573	06010	2016-02-29 21:53:01.736444	Test	646	1	2016-03-17 09:19:04.94469
+574	11010	2016-02-29 21:53:01.736444	Test	699	1	2016-03-17 09:19:04.94469
+575	11010	2016-02-29 21:53:01.736444	Test	697	1	2016-03-17 09:19:04.94469
+579	11010	2016-02-29 21:53:01.736444	Test	765	1	2016-03-17 09:19:04.94469
+578	11010	2016-02-29 21:53:01.736444	Test	764	1	2016-03-17 09:19:04.94469
+576	06060	2016-02-29 21:53:01.736444	Test	876	1	2016-03-17 09:19:04.94469
+577	06060	2016-02-29 21:53:01.736444	Test	877	1	2016-03-17 09:19:04.94469
+580	11010	2016-02-29 21:53:01.736444	Test	693	1	2016-03-17 09:19:04.94469
+581	11010	2016-02-29 21:53:01.736444	Test	604	1	2016-03-17 09:19:04.94469
+582	06010	2016-02-29 21:53:01.736444	Test	455	1	2016-03-17 09:19:04.94469
+583	11010	2016-02-29 21:53:01.736444	Test	677	1	2016-03-17 09:19:04.94469
+584	11010	2016-02-29 21:53:01.736444	Test	679	1	2016-03-17 09:19:04.94469
+585	06010	2016-02-29 21:53:01.736444	Test	907	1	2016-03-17 09:19:04.94469
+586	06010	2016-02-29 21:53:01.736444	Test	409	1	2016-03-17 09:19:04.94469
+587	06010	2016-02-29 21:53:01.736444	Test	45	1	2016-03-17 09:19:04.94469
+588	06010	2016-02-29 21:53:01.736444	Test	404	1	2016-03-17 09:19:04.94469
+589	11010	2016-02-29 21:53:01.736444	Test	669	1	2016-03-17 09:19:04.94469
+590	06010	2016-02-29 21:53:01.736444	Test	382	1	2016-03-17 09:19:04.94469
+591	11010	2016-02-29 21:53:01.736444	Test	687	1	2016-03-17 09:19:04.94469
+592	11010	2016-02-29 21:53:01.736444	Test	686	1	2016-03-17 09:19:04.94469
+593	06010	2016-02-29 21:53:01.736444	Test	906	1	2016-03-17 09:19:04.94469
+594	11010	2016-02-29 21:53:01.736444	Test	682	1	2016-03-17 09:19:04.94469
+595	11010	2016-02-29 21:53:01.736444	Test	749	1	2016-03-17 09:19:04.94469
+596	11010	2016-02-29 21:53:01.736444	Test	855	1	2016-03-17 09:19:04.94469
+597	11010	2016-02-29 21:53:01.736444	Test	856	1	2016-03-17 09:19:04.94469
+598	11010	2016-02-29 21:53:01.736444	Test	857	1	2016-03-17 09:19:04.94469
+599	11010	2016-02-29 21:53:01.736444	Test	858	1	2016-03-17 09:19:04.94469
+600	11010	2016-02-29 21:53:01.736444	Test	859	1	2016-03-17 09:19:04.94469
+601	06010	2016-02-29 21:53:01.736444	Test	781	1	2016-03-17 09:19:04.94469
+602	06010	2016-02-29 21:53:01.736444	Test	782	1	2016-03-17 09:19:04.94469
+603	06010	2016-02-29 21:53:01.736444	Test	783	1	2016-03-17 09:19:04.94469
+604	06010	2016-02-29 21:53:01.736444	Test	784	1	2016-03-17 09:19:04.94469
+605	06010	2016-02-29 21:53:01.736444	Test	776	1	2016-03-17 09:19:04.94469
+606	06010	2016-02-29 21:53:01.736444	Test	777	1	2016-03-17 09:19:04.94469
+607	06010	2016-02-29 21:53:01.736444	Test	778	1	2016-03-17 09:19:04.94469
+608	06010	2016-02-29 21:53:01.736444	Test	779	1	2016-03-17 09:19:04.94469
+609	06010	2016-02-29 21:53:01.736444	Test	457	1	2016-03-17 09:19:04.94469
+610	06010	2016-02-29 21:53:01.736444	Test	546	1	2016-03-17 09:19:04.94469
+611	06010	2016-02-29 21:53:01.736444	Test	547	1	2016-03-17 09:19:04.94469
+612	06010	2016-02-29 21:53:01.736444	Test	536	1	2016-03-17 09:19:04.94469
+613	06010	2016-02-29 21:53:01.736444	Test	552	1	2016-03-17 09:19:04.94469
+614	06010	2016-02-29 21:53:01.736444	Test	553	1	2016-03-17 09:19:04.94469
+615	11010	2016-02-29 21:53:01.736444	Test	841	1	2016-03-17 09:19:04.94469
+616	06010	2016-02-29 21:53:01.736444	Test	574	1	2016-03-17 09:19:04.94469
+617	06060	2016-02-29 21:53:01.736444	Test	558	1	2016-03-17 09:19:04.94469
+618	06060	2016-02-29 21:53:01.736444	Test	559	1	2016-03-17 09:19:04.94469
+619	11010	2016-02-29 21:53:01.736444	Test	847	1	2016-03-17 09:19:04.94469
+620	11010	2016-02-29 21:53:01.736444	Test	835	1	2016-03-17 09:19:04.94469
+621	11010	2016-02-29 21:53:01.736444	Test	792	1	2016-03-17 09:19:04.94469
+622	11010	2016-02-29 21:53:01.736444	Test	793	1	2016-03-17 09:19:04.94469
+623	11010	2016-02-29 21:53:01.736444	Test	794	1	2016-03-17 09:19:04.94469
+624	11010	2016-02-29 21:53:01.736444	Test	795	1	2016-03-17 09:19:04.94469
+625	11010	2016-02-29 21:53:01.736444	Test	796	1	2016-03-17 09:19:04.94469
+626	11010	2016-02-29 21:53:01.736444	Test	593	1	2016-03-17 09:19:04.94469
+627	11010	2016-02-29 21:53:01.736444	Test	594	1	2016-03-17 09:19:04.94469
+628	11010	2016-02-29 21:53:01.736444	Test	595	1	2016-03-17 09:19:04.94469
+629	11010	2016-02-29 21:53:01.736444	Test	596	1	2016-03-17 09:19:04.94469
+630	11010	2016-02-29 21:53:01.736444	Test	597	1	2016-03-17 09:19:04.94469
+631	06010	2016-02-29 21:53:01.736444	Test	649	1	2016-03-17 09:19:04.94469
+632	06010	2016-02-29 21:53:01.736444	Test	499	1	2016-03-17 09:19:04.94469
+633	06010	2016-02-29 21:53:01.736444	Test	517	1	2016-03-17 09:19:04.94469
+634	06010	2016-02-29 21:53:01.736444	Test	515	1	2016-03-17 09:19:04.94469
+635	06010	2016-02-29 21:53:01.736444	Test	518	1	2016-03-17 09:19:04.94469
+636	06010	2016-02-29 21:53:01.736444	Test	513	1	2016-03-17 09:19:04.94469
+637	06010	2016-02-29 21:53:01.736444	Test	538	1	2016-03-17 09:19:04.94469
+638	06010	2016-02-29 21:53:01.736444	Test	539	1	2016-03-17 09:19:04.94469
+639	06010	2016-02-29 21:53:01.736444	Test	639	1	2016-03-17 09:19:04.94469
+640	06010	2016-02-29 21:53:01.736444	Test	640	1	2016-03-17 09:19:04.94469
+645	11010	2016-02-29 21:53:01.736444	Test	788	1	2016-03-17 09:19:04.94469
+641	06010	2016-02-29 21:53:01.736444	Test	901	1	2016-03-17 09:19:04.94469
+642	11010	2016-02-29 21:53:01.736444	Test	900	1	2016-03-17 09:19:04.94469
+643	11010	2016-02-29 21:53:01.736444	Test	789	1	2016-03-17 09:19:04.94469
+646	11010	2016-02-29 21:53:01.736444	Test	785	1	2016-03-17 09:19:04.94469
+647	06060	2016-02-29 21:53:01.736444	Test	533	1	2016-03-17 09:19:04.94469
+648	06010	2016-02-29 21:53:01.736444	Test	529	1	2016-03-17 09:19:04.94469
+649	06010	2016-02-29 21:53:01.736444	Test	530	1	2016-03-17 09:19:04.94469
+650	06010	2016-02-29 21:53:01.736444	Test	452	1	2016-03-17 09:19:04.94469
+651	06010	2016-02-29 21:53:01.736444	Test	451	1	2016-03-17 09:19:04.94469
+653	06060	2016-02-29 21:53:01.736444	Test	411	1	2016-03-17 09:19:04.94469
+654	12020	2016-02-29 21:53:01.736444	Test	195	1	2016-03-17 09:19:04.94469
 \.
 
 
@@ -1189,20 +1004,6 @@
 
 ALTER TABLE zusatz_wert ENABLE TRIGGER ALL;
 
-SET search_path = bund, pg_catalog;
-
-SELECT pg_catalog.setval('kommentar_id_seq', 661, true);
-
-SELECT pg_catalog.setval('messung_id_seq', 1009, true);
-
-SELECT pg_catalog.setval('messwert_id_seq', 6471, true);
-
-SELECT pg_catalog.setval('ort_id_seq', 921, true);
-
-SELECT pg_catalog.setval('probe_id_seq', 734, true);
-
-SELECT pg_catalog.setval('zusatz_wert_id_seq', 30, true);
-
 --
 -- PostgreSQL database dump complete
 --
--- a/db_schema/stammdaten_data.sql	Mon Jul 04 12:10:44 2016 +0200
+++ b/db_schema/stammdaten_data.sql	Mon Jul 04 14:11:00 2016 +0200
@@ -24,44 +24,44 @@
 -- Data for Name: netz_betreiber; Type: TABLE DATA; Schema: stammdaten; Owner: lada
 --
 
-COPY netz_betreiber (id, netzbetreiber, idf_netzbetreiber, is_bmn, mailverteiler, aktiv, zust_mst_id) FROM stdin;
-X	ausländ. Messnetze	\N	t	X	t	\N
-PA	Park	R	t	PA	t	\N
-A	BfS (Spuren)	A	t	A	t	\N
-B	vTI	\N	t	B	t	\N
-D	BfS/ZdB	D	t	D	t	\N
-E	BfE	\N	t	E	t	\N
-F	FhG	\N	t	F	f	\N
-G	BfG	\N	t	G	t	\N
-H	BSH	\N	t	H	t	\N
-I	BfS (LSt. AB)	\N	t	I	t	\N
-L	BfS (LSt. TW ...)	\N	t	L	t	\N
-M	BMU	\N	t	M	t	\N
-N	MRI	\N	t	N	t	\N
-S	Sonstige	\N	t	S	t	\N
-T	PTB	\N	t	T	t	\N
-U	BfS (ABI)	U	t	U	t	\N
-W	DWD	W	t	W	t	\N
-Z	BfS (ODL)	Z	t	Z	t	\N
-01	Schleswig-Holstein	a	f	01	t	\N
-02	Hamburg	b	f	02	t	\N
-03	Niedersachsen	c	f	03	t	\N
-04	Bremen	d	f	04	t	\N
-05	Nordrhein-Westfalen	e	f	05	t	\N
-06	Hessen	f	f	06	t	\N
-07	Rheinland-Pfalz	g	f	07	t	\N
-08	Baden-Württemberg	h	f	08	t	\N
-09	Bayern	i	f	09	t	\N
-10	Saarland	j	f	10	t	\N
-11	Berlin	k	f	11	t	\N
-12	Brandenburg	l	f	12	t	\N
-13	Mecklenburg-Vorpommern	m	f	13	t	\N
-14	Sachsen	n	f	14	t	\N
-15	Sachsen-Anhalt	o	f	15	t	\N
-16	Thüringen	p	f	16	t	\N
-18	Endlager (Bundesaufsicht)	r	f	18	t	\N
-19	ZdB-Testnetz	s	f	19	t	\N
-17	Bundeswehr	q	f	17	t	\N
+COPY netz_betreiber (id, netzbetreiber, idf_netzbetreiber, is_bmn, mailverteiler, aktiv) FROM stdin;
+X	ausländ. Messnetze	\N	t	X	t
+PA	Park	R	t	PA	t
+A	BfS (Spuren)	A	t	A	t
+B	vTI	\N	t	B	t
+D	BfS/ZdB	D	t	D	t
+E	BfE	\N	t	E	t
+F	FhG	\N	t	F	f
+G	BfG	\N	t	G	t
+H	BSH	\N	t	H	t
+I	BfS (LSt. AB)	\N	t	I	t
+L	BfS (LSt. TW ...)	\N	t	L	t
+M	BMU	\N	t	M	t
+N	MRI	\N	t	N	t
+S	Sonstige	\N	t	S	t
+T	PTB	\N	t	T	t
+U	BfS (ABI)	U	t	U	t
+W	DWD	W	t	W	t
+Z	BfS (ODL)	Z	t	Z	t
+01	Schleswig-Holstein	a	f	01	t
+02	Hamburg	b	f	02	t
+03	Niedersachsen	c	f	03	t
+04	Bremen	d	f	04	t
+05	Nordrhein-Westfalen	e	f	05	t
+06	Hessen	f	f	06	t
+07	Rheinland-Pfalz	g	f	07	t
+08	Baden-Württemberg	h	f	08	t
+09	Bayern	i	f	09	t
+10	Saarland	j	f	10	t
+11	Berlin	k	f	11	t
+12	Brandenburg	l	f	12	t
+13	Mecklenburg-Vorpommern	m	f	13	t
+14	Sachsen	n	f	14	t
+15	Sachsen-Anhalt	o	f	15	t
+16	Thüringen	p	f	16	t
+18	Endlager (Bundesaufsicht)	r	f	18	t
+19	ZdB-Testnetz	s	f	19	t
+17	Bundeswehr	q	f	17	t
 \.
 
 
@@ -699,7 +699,7 @@
 -- Data for Name: auth_lst_umw; Type: TABLE DATA; Schema: stammdaten; Owner: lada
 --
 
-COPY auth_lst_umw (id, lst_id, umw_id) FROM stdin;
+COPY auth_lst_umw (id, mst_id, umw_id) FROM stdin;
 1	20050	F11
 2	20050	F21
 3	20050	I11
@@ -924,7 +924,7 @@
 -- Data for Name: datensatz_erzeuger; Type: TABLE DATA; Schema: stammdaten; Owner: lada
 --
 
-COPY datensatz_erzeuger (id, netzbetreiber_id, da_erzeuger_id, mst_id, bezeichnung, letzte_aenderung) FROM stdin;
+COPY datensatz_erzeuger (id, netzbetreiber_id, datensatz_erzeuger_id, mst_id, bezeichnung, letzte_aenderung) FROM stdin;
 1	06	KS	06010	Messstelle HLUG Kassel	2000-01-01 00:00:00
 2	06	DA	06060	Messstelle HLUG Darmstadt	2000-01-01 00:00:00
 \.
@@ -23128,7 +23128,7 @@
 -- Data for Name: messprogramm_kategorie; Type: TABLE DATA; Schema: stammdaten; Owner: lada
 --
 
-COPY messprogramm_kategorie (id, netzbetreiber_id, mpl_id, bezeichnung, letzte_aenderung) FROM stdin;
+COPY messprogramm_kategorie (id, netzbetreiber_id, code, bezeichnung, letzte_aenderung) FROM stdin;
 56	12	AK	Kontrolle Eigenüberwachung,  Probenahme durch Kraftwerk	2000-01-01 00:00:00
 57	12	AU	zu MB=S, Altlast Auer	2000-01-01 00:00:00
 58	12	BAS	zu MB=S, Altlasten BASF	2000-01-01 00:00:00
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)