Mercurial > lada > lada-server

changeset 1319:512616ea3228 release-2.5

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
fix somme test data
author Michael Stanko <mstanko@bfs.de>
date Thu, 23 Mar 2017 09:02:26 +0100
parents 3ac30d816c9a
children bfbbd390c9a8
files db_schema/lada_data.sql db_schema/lada_messprogramm.sql db_schema/setup-db.sh db_schema/stammdaten_data_query.sql
diffstat 4 files changed, 162 insertions(+), 97 deletions(-) [+]
line wrap: on
line diff
--- a/db_schema/lada_data.sql	Mon Mar 20 15:52:22 2017 +0100
+++ b/db_schema/lada_data.sql	Thu Mar 23 09:02:26 2017 +0100
@@ -29,62 +29,62 @@
 ALTER TABLE probe DISABLE TRIGGER ALL;
 
 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	1	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	1420	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	714	\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	1436	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	1424	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
+660	000007590041X	t	12020	12020	N0013KE12	2	1	1	D: 01 03 52 02 00 00 00 00 00 00 00 00	Schafkäse	N92	2012-01-26 11:30:00+01	\N	\N	2017-03-22 20:10:18.048436	\N	784	\N	\N	2012-01-01 00:00:00	2012-01-31 21:59:59	2017-03-22 20:10:18.048436
+409	000007589343X	t	12010	12010	A0239MP12	2	1	1	D: 01 02 07 03 00 00 00 00 00 00 00 00	Magermilchpulver	N94	2012-03-15 11:00:00+01	\N	\N	2017-03-22 20:10:18.048436	\N	1199	\N	\N	2012-03-01 00:00:00	2012-03-31 21:59:59	2017-03-22 20:10:18.048436
+42	000007578227X	t	06010	06010	120109003	2	1	1	D: 01 03 26 03 04 02 00 00 00 00 00 00	Frischkäse Fettstufe auch mit Gewürzen/Kräutern	N91	2012-01-04 08:00:00+01	\N	\N	2017-03-22 20:10:18.048436	\N	734	\N	\N	2012-01-01 00:00:00	2012-01-31 21:59:59	2017-03-22 20:10:18.048436
+313	000007575969X	t	11010	11010	122200001	2	1	1	D: 01 06 35 04 01 02 02 20 00 00 00 00	Suppenhuhn auch tiefgefroren	N54	2012-02-24 09:30:00+01	2012-02-24 09:30:00+01	\N	2017-03-22 20:10:18.048436	\N	\N	\N	\N	2012-01-01 00:00:00	2012-12-31 21:59:59	2017-03-22 20:10:18.048436
+311	000007575967X	t	11010	11010	122100011	2	1	1	D: 01 06 40 04 01 02 02 11 00 00 00 00	Fleischteilstück Reh auch tiefgefroren	N56	2012-06-04 10:00:00+02	2012-06-04 10:00:00+02	\N	2017-03-22 20:10:18.048436	\N	\N	\N	\N	2012-01-01 00:00:00	2012-06-30 21:59:59	2017-03-22 20:10:18.048436
+112	000007575752X	t	11010	11010	122800001	2	1	1	D: 01 01 01 02 01 02 00 20 00 00 00 00	Milch ab Hof	A13	2012-01-10 09:30:00+01	2012-01-10 09:30:00+01	\N	2017-03-22 20:10:18.048436	\N	\N	\N	\N	2012-01-09 00:00:00	2012-01-15 21:59:59	2017-03-22 20:10:18.048436
+117	000007578031X	t	06060	06060	1420	2	1	1	D: 01 01 01 01 02 00 00 00 00 00 00 00	Sammelmilch	N11	2012-01-25 11:00:00+01	\N	\N	2017-03-22 20:10:18.048436	553	727	\N	\N	2012-01-23 00:00:00	2012-01-29 21:59:59	2017-03-22 20:10:18.048436
+307	000007575960X	t	11010	11010	122100004	2	1	1	D: 01 06 16 19 01 02 02 20 00 00 00 00	Schnitzel Schwein auch tiefgefroren	N53	2012-02-24 09:30:00+01	2012-02-24 09:30:00+01	\N	2017-03-22 20:10:18.048436	\N	\N	\N	\N	2012-01-01 00:00:00	2012-03-31 21:59:59	2017-03-22 20:10:18.048436
+203	000007575864X	t	11010	11010	122400003	2	1	1	D: 01 10 29 50 01 02 05 01 02 00 00 00	Schleie (Tinca tinca) Süßwasserfisch	N61	2012-06-01 09:00:00+02	2012-06-01 09:00:00+02	\N	2017-03-22 20:10:18.048436	\N	\N	\N	\N	2012-03-26 00:00:00	2012-12-09 21:59:59	2017-03-22 20:10:18.048436
+357	000007578195X	t	06010	06010	120110255	2	1	1	D: 01 12 01 13 04 02 02 00 00 00 00 00	Tiefseegarnele (Pandalus sp.)	N63	2012-01-10 10:00:00+01	\N	\N	2017-03-22 20:10:18.048436	\N	734	\N	\N	2012-01-01 00:00:00	2012-01-31 21:59:59	2017-03-22 20:10:18.048436
+292	000007575939X	t	11010	11010	121300007	2	1	1	D: 01 15 01 01 01 02 01 00 00 00 00 00	Weizenkörner	N31	2012-01-27 10:15:00+01	2012-01-27 10:15:00+01	\N	2017-03-22 20:10:18.048436	\N	\N	\N	\N	2012-01-01 00:00:00	2012-12-31 21:59:59	2017-03-22 20:10:18.048436
+294	000007575941X	t	11010	11010	121300009	2	1	1	D: 01 15 06 03 01 02 01 00 00 00 00 00	Langkornreis	N3Z	2012-01-27 10:45:00+01	2012-01-27 10:45:00+01	\N	2017-03-22 20:10:18.048436	\N	\N	\N	\N	2012-01-01 00:00:00	2012-12-31 21:59:59	2017-03-22 20:10:18.048436
+25	000007587696X	t	06010	06010	120614003	2	1	1	D: 01 29 01 02 00 00 00 00 02 00 00 00	Erdbeere	N44	2012-06-14 08:00:00+02	\N	\N	2017-03-22 20:10:18.048436	\N	92	\N	\N	2012-07-01 00:00:00	2012-07-31 21:59:59	2017-03-22 20:10:18.048436
+145	000007578087X	t	06010	06010	120425002	2	1	1	D: 01 24 01 02 04 00 00 00 00 00 00 00	Kartoffel festkochend (Salatware)	N25	2012-04-24 11:00:00+02	\N	\N	2017-03-22 20:10:18.048436	\N	734	\N	\N	2012-04-01 00:00:00	2012-04-30 21:59:59	2017-03-22 20:10:18.048436
+4	000007587554X	t	06010	06010	120619003	2	1	1	D: 01 25 01 01 00 00 00 00 02 00 00 00	Kopfsalat	N21	2012-06-18 09:30:00+02	\N	\N	2017-03-22 20:10:18.048436	\N	78	\N	\N	2012-06-01 00:00:00	2012-07-31 21:59:59	2017-03-22 20:10:18.048436
+140	000007578082X	t	06010	06010	120109006	2	1	1	D: 01 25 03 02 04 02 00 00 02 00 00 00	Gemüsepaprika	N23	2012-01-04 06:30:00+01	\N	\N	2017-03-22 20:10:18.048436	\N	734	\N	\N	2012-01-01 00:00:00	2012-01-31 21:59:59	2017-03-22 20:10:18.048436
+284	000007575917X	t	11010	11010	121100004	2	1	1	D: 01 25 04 06 01 02 02 00 02 00 00 00	Radieschen	N22	2012-06-04 09:30:00+02	2012-06-04 09:30:00+02	\N	2017-03-22 20:10:18.048436	\N	\N	\N	\N	2012-05-21 00:00:00	2012-07-01 21:59:59	2017-03-22 20:10:18.048436
+703	000007590316X	t	06010	06010	120426001	2	1	1	D: 01 27 08 03 01 00 02 00 00 00 00 00	Speisemorchel (Morchella esculenta)	N2A	2012-04-24 22:00:00+02	\N	\N	2017-03-22 20:10:18.048436	\N	977	716	\N	2012-01-10 00:00:00	2012-01-10 21:59:59	2017-03-22 20:10:18.048436
+301	000007575950X	t	11010	11010	121200009	2	1	1	D: 01 29 01 14 01 02 02 00 00 00 00 00	Moosbeere	N46	2012-01-27 10:30:00+01	2012-01-27 10:30:00+01	\N	2017-03-22 20:10:18.048436	\N	\N	\N	\N	2012-01-01 00:00:00	2012-12-31 21:59:59	2017-03-22 20:10:18.048436
+300	000007575949X	t	11010	11010	121200008	2	1	1	D: 01 29 02 01 01 02 02 00 00 00 00 00	Apfel	N42	2012-01-27 10:45:00+01	2012-01-27 10:45:00+01	\N	2017-03-22 20:10:18.048436	\N	\N	\N	\N	2012-01-01 00:00:00	2012-12-31 21:59:59	2017-03-22 20:10:18.048436
+24	000007587691X	t	06010	06010	120619004	2	1	1	D: 01 29 03 07 00 00 00 00 00 00 00 00	Süßkirsche	N43	2012-06-18 11:30:00+02	\N	\N	2017-03-22 20:10:18.048436	\N	78	\N	\N	2012-06-01 00:00:00	2012-06-30 21:59:59	2017-03-22 20:10:18.048436
+296	000007575943X	t	11010	11010	121200002	2	1	1	D: 01 29 05 14 01 02 02 00 02 00 00 00	Rhabarber	N4Z	2012-05-07 10:10:00+02	2012-05-07 10:10:00+02	\N	2017-03-22 20:10:18.048436	\N	\N	\N	\N	2012-08-06 00:00:00	2012-10-21 21:59:59	2017-03-22 20:10:18.048436
+99	000007575726X	t	11010	11010	123100001	2	1	3	D: 01 50 90 01 06 02 05 00 00 00 00 51 00	Tageskost einschl. flüssiger Bestandteile und Getränke	N81	2012-01-03 23:00:00+01	2012-01-04 22:00:00+01	82800	2017-03-22 20:10:18.048436	\N	\N	\N	\N	2012-01-02 00:00:00	2012-01-15 21:59:59	2017-03-22 20:10:18.048436
+67	000007578283X	t	06010	06010	120309009	2	1	1	D: 09 01 07 01 00 00 00 00 00 00 00 00	Reststoffe aus Verbrennungsanlagen	A22	2012-03-09 11:30:00+01	\N	\N	2017-03-22 20:10:18.048436	\N	813	\N	\N	2012-03-05 00:00:00	2012-03-11 21:59:59	2017-03-22 20:10:18.048436
+194	000007575847X	t	11010	11010	125500001	2	1	1	D: 01 59 01 01 05 02 03 03 01 01 00 00	Rohwasser aus Grundwasser nicht aufbereitet	G51	2012-03-02 12:10:00+01	2012-03-02 12:10:00+01	\N	2017-03-22 20:10:18.048436	\N	\N	\N	\N	2012-01-09 00:00:00	2012-04-01 21:59:59	2017-03-22 20:10:18.048436
+3	000007581040X	t	06010	06010	120515001	2	1	1	D: 01 59 03 01 01 02 05 01 02 00 00 00	Trinkwasser Zentralversorgung Grundwasser aufbereitet	N71	2012-05-10 11:00:00+02	\N	\N	2017-03-22 20:10:18.048436	\N	714	\N	\N	2012-05-07 00:00:00	2012-05-13 21:59:59	2017-03-22 20:10:18.048436
+1	000007581034X	t	06010	06010	120510002	2	1	1	D: 01 59 04 01 00 05 05 01 02 00 00 00	Trinkwasser Zentralversorgung Oberflächenwasser aufbereitet	N72	2012-05-08 11:00:00+02	\N	\N	2017-03-22 20:10:18.048436	\N	726	\N	\N	2012-05-07 00:00:00	2012-05-13 21:59:59	2017-03-22 20:10:18.048436
+31	000007578204X	t	06010	06010	120210003	2	1	1	D: 01 59 05 01 05 05 05 01 02 00 00 00	Trinkwasser aus Mischwasser Zentralversorgung aufbereitet	N73	2012-02-07 23:00:00+01	\N	\N	2017-03-22 20:10:18.048436	\N	724	\N	\N	2012-02-06 00:00:00	2012-02-12 21:59:59	2017-03-22 20:10:18.048436
+84	000007578312X	t	06010	06010	120404004	2	1	1	D: 04 01 98 01 00 00 23 07 00 72 03 00	Unbearbeiteter Boden	B33	2012-04-02 12:30:00+02	\N	\N	2017-03-22 20:10:18.048436	\N	60	\N	\N	2012-04-02 00:00:00	2012-04-08 21:59:59	2017-03-22 20:10:18.048436
+76	000007578301X	t	06010	06010	120326001	2	1	1	D: 04 01 42 28 00 00 10 08 00 31 03 00	Unbearbeiteter Boden	B31	2012-03-26 09:00:00+02	\N	\N	2017-03-22 20:10:18.048436	\N	813	\N	\N	2012-04-02 00:00:00	2012-04-08 21:59:59	2017-03-22 20:10:18.048436
+88	000007578316X	t	06010	06010	120326002	2	1	1	D: 04 01 24 84 00 00 60 15 00 31 07 00	Unbearbeiteter Boden	B34	2012-03-26 10:40:00+02	\N	\N	2017-03-22 20:10:18.048436	\N	813	\N	\N	2012-04-02 00:00:00	2012-04-08 21:59:59	2017-03-22 20:10:18.048436
+180	000007575819X	t	11010	11010	126100037	2	1	1	D: 06 04 05 01 00 00 00 02 01 01 00 00	Sediment	G13	2012-03-12 10:30:00+01	2012-03-12 10:30:00+01	\N	2017-03-22 20:10:18.048436	\N	\N	\N	\N	2012-01-01 00:00:00	2012-03-31 21:59:59	2017-03-22 20:10:18.048436
+97	000007578331X	t	06010	06010	120306001	2	1	3	D: 06 05 00 01 00 00 00 06 00 00 01 00	Schwebstoffe	G12	2012-01-24 09:00:00+01	2012-02-24 09:00:00+01	2678400	2017-03-22 20:10:18.048436	\N	60	\N	\N	2012-01-23 00:00:00	2012-02-19 21:59:59	2017-03-22 20:10:18.048436
+91	000007578319X	t	06060	06060	14246	2	1	1	D: 06 02 00 01 00 00 01 02 02 00 00 00	Oberflächenwasser	G11	2012-02-13 11:00:00+01	\N	\N	2017-03-22 20:10:18.048436	553	60	\N	\N	2012-02-13 00:00:00	2012-02-19 21:59:59	2017-03-22 20:10:18.048436
+186	000007575831X	t	11010	11010	126100049	2	1	1	D: 06 05 00 02 00 00 00 01 00 00 00 00	Schwebstoffe	G22	2012-03-06 11:00:00+01	2012-03-06 11:00:00+01	\N	2017-03-22 20:10:18.048436	\N	\N	\N	\N	2012-01-01 00:00:00	2012-03-31 21:59:59	2017-03-22 20:10:18.048436
+174	000007575807X	t	11010	11010	126100025	2	1	1	D: 06 04 05 02 00 00 00 02 01 01 00 00	Sediment	G23	2012-03-06 11:00:00+01	2012-03-06 11:00:00+01	\N	2017-03-22 20:10:18.048436	\N	\N	\N	\N	2012-01-01 00:00:00	2012-03-31 21:59:59	2017-03-22 20:10:18.048436
+160	000007575783X	t	11010	11010	126100001	2	1	3	D: 06 02 00 02 00 00 01 04 02 00 00 00	Oberflächenwasser	G21	2012-01-17 11:00:00+01	2012-03-13 11:00:00+01	4838400	2017-03-22 20:10:18.048436	\N	\N	\N	\N	2012-01-01 00:00:00	2012-03-31 21:59:59	2017-03-22 20:10:18.048436
+200	000007575856X	t	11010	11010	125500010	2	1	1	D: 06 03 00 01 00 00 01 03 00 00 00 00	Grundwasser	G41	2012-04-27 07:00:00+02	2012-04-27 07:00:00+02	\N	2017-03-22 20:10:18.048436	\N	\N	\N	\N	2012-01-01 00:00:00	2012-06-30 21:59:59	2017-03-22 20:10:18.048436
+45	000007578239X	t	06010	06010	120120005	2	1	1	D: 08 01 03 01 00 00 00 06 00 00 00 00	Abwasser	A11	2012-01-19 06:00:00+01	\N	\N	2017-03-22 20:10:18.048436	\N	60	\N	\N	2012-01-09 00:00:00	2012-01-15 21:59:59	2017-03-22 20:10:18.048436
+55	000007578259X	t	06010	06010	120120006	2	1	1	D: 08 02 04 01 00 00 04 02 00 00 00 00	Schlamm aus Abwässern	A13	2012-01-19 07:00:00+01	\N	\N	2017-03-22 20:10:18.048436	\N	60	\N	\N	2012-01-09 00:00:00	2012-01-15 21:59:59	2017-03-22 20:10:18.048436
+69	000007578287X	t	06010	06010	120309008	2	1	1	D: 09 01 16 01 00 00 00 00 00 00 00 00	Reststoffe aus Verbrennungsanlagen	A23	2012-03-09 11:30:00+01	\N	\N	2017-03-22 20:10:18.048436	\N	813	\N	\N	2012-03-05 00:00:00	2012-03-11 21:59:59	2017-03-22 20:10:18.048436
+70	000007578289X	t	06010	06010	120309004	2	1	1	D: 09 01 14 05 00 00 00 00 00 00 00 00	Reststoffe aus Verbrennungsanlagen	A24	2012-03-07 09:00:00+01	\N	\N	2017-03-22 20:10:18.048436	\N	60	\N	\N	2012-03-05 00:00:00	2012-03-11 21:59:59	2017-03-22 20:10:18.048436
+65	000007578279X	t	06010	06010	120309005	2	1	1	D: 09 01 02 05 00 00 00 00 00 00 00 00	Reststoffe aus Verbrennungsanlagen	A21	2012-03-07 09:00:00+01	\N	\N	2017-03-22 20:10:18.048436	\N	60	\N	\N	2012-03-05 00:00:00	2012-03-11 21:59:59	2017-03-22 20:10:18.048436
+78	000007578303X	t	06010	06010	120330006	2	1	1	D: 04 02 42 26 00 00 01 25 00 31 03 00	Ackerboden	B32	2012-03-28 11:00:00+02	\N	\N	2017-03-22 20:10:18.048436	\N	60	\N	\N	2012-04-02 00:00:00	2012-04-08 21:59:59	2017-03-22 20:10:18.048436
+36	000007578214X	t	06010	06010	120502004	2	1	1	D: 01 48 25 04 02 00 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	2017-03-22 20:10:18.048436	\N	729	\N	\N	2012-04-01 00:00:00	2012-04-30 21:59:59	2017-03-22 20:10:18.048436
+157	000007575772X	t	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 00	Grünfutter	A3	2012-05-21 09:30:00+02	2012-05-21 09:30:00+02	\N	2017-03-22 20:10:18.048436	\N	\N	\N	\N	2012-04-16 00:00:00	2012-06-17 21:59:59	2017-03-22 20:10:18.048436
+19	000007587671X	t	06010	06010	120614002	2	1	1	D: 01 25 02 25 00 00 00 00 02 00 00 00	Spargel, weiß	N24	2012-06-14 07:00:00+02	\N	\N	2017-03-22 20:10:18.048436	\N	92	\N	\N	2012-06-01 00:00:00	2012-06-30 21:59:59	2017-03-22 20:10:18.048436
+707	000007613597X	t	11010	11010	125100012	2	1	1	D: 02 02 20 00 00 02 00 00 00 00 00 00	Silagen	F5Z	2012-01-11 10:00:00+01	2012-01-11 10:00:00+01	\N	2017-03-22 20:10:18.048436	\N	\N	\N	\N	\N	\N	2017-03-22 20:10:18.048436
+158	000007575778X	t	11010	11010	125100007	2	1	1	D: 02 06 48 00 00 01 00 00 00 00 00 00	Nebenerzeugnisse trocken	F62	2012-01-27 10:15:00+01	2012-01-27 10:15:00+01	\N	2017-03-22 20:10:18.048436	\N	\N	\N	\N	2012-01-01 00:00:00	2012-12-31 21:59:59	2017-03-22 20:10:18.048436
+155	000007575767X	t	11010	11010	125300001	2	1	1	D: 03 09 01 00 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	2017-03-22 20:10:18.048436	\N	\N	\N	\N	2012-05-07 00:00:00	2012-09-30 21:59:59	2017-03-22 20:10:18.048436
+73	000007578295X	t	06060	06060	1436	2	1	1	D: 09 03 00 00 00 00 00 00 00 00 00 00	Kompostierung	A41	2012-05-10 10:00:00+02	\N	\N	2017-03-22 20:10:18.048436	553	813	\N	\N	2012-05-07 00:00:00	2012-05-13 21:59:59	2017-03-22 20:10:18.048436
+71	000007578291X	t	06010	06010	120523008	2	1	1	D: 09 02 08 00 00 00 00 00 00 00 00 00	Deponie	A31	2012-05-11 10:30:00+02	\N	\N	2017-03-22 20:10:18.048436	\N	813	\N	\N	2012-05-07 00:00:00	2012-05-13 21:59:59	2017-03-22 20:10:18.048436
+354	000007578191X	t	06010	06010	120110258	2	1	1	D: 01 10 55 00 00 00 00 00 00 00 00 00	Barschartige Fische Seefische Zuschnitte	N62	2012-01-10 09:00:00+01	\N	\N	2017-03-22 20:10:18.048436	\N	734	\N	\N	2012-01-01 00:00:00	2012-01-31 21:59:59	2017-03-22 20:10:18.048436
+353	000007578188X	t	06010	06010	120117004	2	1	1	D: 01 06 23 00 05 02 02 00 00 00 00 00	Fleischteilstücke Lamm/Schaf auch tiefgefroren	N55	2012-01-17 10:00:00+01	\N	\N	2017-03-22 20:10:18.048436	\N	734	\N	\N	2012-01-01 00:00:00	2012-06-30 21:59:59	2017-03-22 20:10:18.048436
+147	000007578141X	t	06060	06060	1424	2	1	1	D: 01 06 02 00 00 00 00 00 00 00 00 00	Fleischteilstücke Rind auch tiefgefroren	N51	2012-02-22 11:00:00+01	\N	\N	2017-03-22 20:10:18.048436	553	714	\N	\N	2012-02-01 00:00:00	2012-02-29 21:59:59	2017-03-22 20:10:18.048436
+406	000007589328X	t	12020	12020	N0198FU12	2	1	1	D: 02 01 16 00 00 00 00 00 00 00 00 00	Grünfutter	F12	2012-06-07 09:00:00+02	\N	\N	2017-03-22 20:10:18.048436	\N	1859	\N	\N	2012-04-01 00:00:00	2012-06-30 21:59:59	2017-03-22 20:10:18.048436
 \.
 
 
@@ -243,51 +243,6 @@
 
 
 --
--- TOC entry 4684 (class 0 OID 1170769)
--- Dependencies: 286
--- Data for Name: messprogramm; Type: TABLE DATA; Schema: land; Owner: postgres
---
-
-ALTER TABLE messprogramm DISABLE TRIGGER ALL;
-
-COPY messprogramm (id, test, mst_id, labor_mst_id, datenbasis_id, ba_id, gem_id, media_desk, mpl_Id, umw_id, probenart_id, probenintervall, teilintervall_von, teilintervall_bis, intervall_offset, gueltig_von, gueltig_bis, probe_nehmer_id, probe_kommentar, letzte_aenderung) FROM stdin;
-\.
-
-
-ALTER TABLE messprogramm ENABLE TRIGGER ALL;
-
---
--- TOC entry 4701 (class 0 OID 0)
--- Dependencies: 285
--- Name: messprogramm_id_seq; Type: SEQUENCE SET; Schema: land; Owner: postgres
---
-
-SELECT pg_catalog.setval('messprogramm_id_seq', 1, false);
-
-
---
--- TOC entry 4685 (class 0 OID 1170813)
--- Dependencies: 287
--- Data for Name: messprogramm_mmt; Type: TABLE DATA; Schema: land; Owner: postgres
---
-
-ALTER TABLE messprogramm_mmt DISABLE TRIGGER ALL;
-
-COPY messprogramm_mmt (id, messprogramm_id, mmt_id, messgroessen, letzte_aenderung) FROM stdin;
-\.
-
-
-ALTER TABLE messprogramm_mmt ENABLE TRIGGER ALL;
-
---
--- TOC entry 4702 (class 0 OID 0)
--- Dependencies: 288
--- Name: messprogramm_mmt_id_seq; Type: SEQUENCE SET; Schema: land; Owner: postgres
---
-
-SELECT pg_catalog.setval('messprogramm_mmt_id_seq', 1, false);
-
---
 -- TOC entry 4690 (class 0 OID 1170837)
 -- Dependencies: 292
 -- Data for Name: messwert; Type: TABLE DATA; Schema: land; Owner: postgres
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/db_schema/lada_messprogramm.sql	Thu Mar 23 09:02:26 2017 +0100
@@ -0,0 +1,65 @@
+\set ON_ERROR_STOP on
+
+--
+-- PostgreSQL database dump
+--
+
+-- Dumped from database version 9.5.2
+-- Dumped by pg_dump version 9.5.2
+
+-- Started on 2016-05-04 09:10:49 CEST
+
+SET statement_timeout = 0;
+SET lock_timeout = 0;
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = on;
+SET check_function_bodies = false;
+SET client_min_messages = warning;
+
+SET search_path = land, pg_catalog;
+
+--
+-- TOC entry 4684 (class 0 OID 1170769)
+-- Dependencies: 286
+-- Data for Name: messprogramm; Type: TABLE DATA; Schema: land; Owner: postgres
+--
+
+ALTER TABLE messprogramm DISABLE TRIGGER ALL;
+
+COPY messprogramm (id, test, mst_id, labor_mst_id, datenbasis_id, ba_id, gem_id, media_desk, mpl_Id, umw_id, probenart_id, probenintervall, teilintervall_von, teilintervall_bis, intervall_offset, gueltig_von, gueltig_bis, probe_nehmer_id, probe_kommentar, letzte_aenderung) FROM stdin;
+\.
+
+
+ALTER TABLE messprogramm ENABLE TRIGGER ALL;
+
+--
+-- TOC entry 4701 (class 0 OID 0)
+-- Dependencies: 285
+-- Name: messprogramm_id_seq; Type: SEQUENCE SET; Schema: land; Owner: postgres
+--
+
+SELECT pg_catalog.setval('messprogramm_id_seq', 1, false);
+
+
+--
+-- TOC entry 4685 (class 0 OID 1170813)
+-- Dependencies: 287
+-- Data for Name: messprogramm_mmt; Type: TABLE DATA; Schema: land; Owner: postgres
+--
+
+ALTER TABLE messprogramm_mmt DISABLE TRIGGER ALL;
+
+COPY messprogramm_mmt (id, messprogramm_id, mmt_id, messgroessen, letzte_aenderung) FROM stdin;
+\.
+
+
+ALTER TABLE messprogramm_mmt ENABLE TRIGGER ALL;
+
+--
+-- TOC entry 4702 (class 0 OID 0)
+-- Dependencies: 288
+-- Name: messprogramm_mmt_id_seq; Type: SEQUENCE SET; Schema: land; Owner: postgres
+--
+
+SELECT pg_catalog.setval('messprogramm_mmt_id_seq', 1, false);
+
--- a/db_schema/setup-db.sh	Mon Mar 20 15:52:22 2017 +0100
+++ b/db_schema/setup-db.sh	Thu Mar 23 09:02:26 2017 +0100
@@ -40,7 +40,7 @@
 DB_CONNECT_STRING="$DB_CONNECT_STRING -U postgres"
 echo "DB_CONNECT_STRING = $DB_CONNECT_STRING"
 
-if [ `psql $DB_CONNECT_STRING -t --command "SELECT count(*) FROM pg_catalog.pg_user WHERE usename = '$ROLE_NAME'"` -eq 0 ] ; then
+if [ `psql $DB_CONNECT_STRING -t --quiet --command "SELECT count(*) FROM pg_catalog.pg_user WHERE usename = '$ROLE_NAME'"` -eq 0 ] ; then
   echo create user $ROLE_NAME
   psql $DB_CONNECT_STRING --command "CREATE USER $ROLE_NAME PASSWORD '$ROLE_PW';"
 fi
@@ -72,6 +72,11 @@
             ON ALL TABLES IN SCHEMA stammdaten, land TO $ROLE_NAME;"
 
 if [ "$NO_DATA" != "true" ]; then
+    if [ -f $DIR/lada_private_data.zip ]; then
+        echo inclue private data
+        unzip -o lada_private_data.zip
+    fi
+
     echo import stammdaten.verwaltungseinheit
     psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/stammdaten_data_verwaltungseinheit.sql
 
@@ -127,9 +132,8 @@
             http://sg.geodatenzentrum.de/web_download/vg/vg250_${TS}/utm32s/shape/vg250_${TS}.utm32s.shape.ebenen.zip
     fi
     unzip -u vg250_${TS}.utm32s.shape.ebenen.zip "*VG250_GEM*"
-#    cd vg250_${TS}.utm32s.shape.ebenen/vg250_ebenen/
+
     shp2pgsql -s 25832:4326 vg250_${TS}.utm32s.shape.ebenen/vg250_ebenen/VG250_GEM geo.gem_utm | psql -q $DB_CONNECT_STRING -d $DB_NAME
-#   rm -rf vg250_${TS}.utm32s.shape.ebenen
 
     echo fille stammdaten.verwaltungsgrenze
     psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/stammdaten_fill_verwaltungsgrenze.sql
--- a/db_schema/stammdaten_data_query.sql	Mon Mar 20 15:52:22 2017 +0100
+++ b/db_schema/stammdaten_data_query.sql	Thu Mar 23 09:02:26 2017 +0100
@@ -1,28 +1,23 @@
-\set ON_ERROR_STOP on
-
---
+\set ON_ERROR_STOP on--
 -- PostgreSQL database dump
 --
 
--- Dumped from database version 9.5.1
--- Dumped by pg_dump version 9.5.0
-
--- Started on 2016-03-31 11:38:13
+-- Dumped from database version 9.6.2
+-- Dumped by pg_dump version 9.6.2
 
 SET statement_timeout = 0;
 SET lock_timeout = 0;
+SET idle_in_transaction_session_timeout = 0;
 SET client_encoding = 'UTF8';
 SET standard_conforming_strings = on;
 SET check_function_bodies = false;
 SET client_min_messages = warning;
+SET row_security = off;
 
 SET search_path = stammdaten, pg_catalog;
 
-
 --
--- TOC entry 4715 (class 0 OID 535823)
--- Dependencies: 281
--- Data for Name: query; Type: TABLE DATA; Schema: stammdaten; Owner: lada
+-- Data for Name: query; Type: TABLE DATA; Schema: stammdaten; Owner: postgres
 --
 
 COPY query (id, name, type, sql, description) FROM stdin;
@@ -43,9 +38,7 @@
 
 
 --
--- TOC entry 4683 (class 0 OID 535720)
--- Dependencies: 248
--- Data for Name: filter; Type: TABLE DATA; Schema: stammdaten; Owner: lada
+-- Data for Name: filter; Type: TABLE DATA; Schema: stammdaten; Owner: postgres
 --
 
 COPY filter (id, query_id, data_index, type, label, multiselect) FROM stdin;
@@ -66,9 +59,21 @@
 
 
 --
--- TOC entry 4717 (class 0 OID 535831)
--- Dependencies: 283
--- Data for Name: result; Type: TABLE DATA; Schema: stammdaten; Owner: lada
+-- Name: filter_id_seq; Type: SEQUENCE SET; Schema: stammdaten; Owner: postgres
+--
+
+SELECT pg_catalog.setval('filter_id_seq', 18, true);
+
+
+--
+-- Name: query_id_seq; Type: SEQUENCE SET; Schema: stammdaten; Owner: postgres
+--
+
+SELECT pg_catalog.setval('query_id_seq', 15, true);
+
+
+--
+-- Data for Name: result; Type: TABLE DATA; Schema: stammdaten; Owner: postgres
 --
 
 COPY result (id, query_id, data_index, header, width, flex, index) FROM stdin;
@@ -189,3 +194,15 @@
 126	15	probeId	Probe_Id	100	f	0
 \.
 
+
+--
+-- Name: result_id_seq; Type: SEQUENCE SET; Schema: stammdaten; Owner: postgres
+--
+
+SELECT pg_catalog.setval('result_id_seq', 126, true);
+
+
+--
+-- PostgreSQL database dump complete
+--
+
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)