# HG changeset patch # User Michael Stanko # Date 1462342051 -7200 # Node ID 6ab17d8b55582e01a9c0a73ac6853178bf9888bb # Parent 690b6506e0a2046a896c810f6353fb84229b9029 erase mpr_id values in lada_data.sql diff -r 690b6506e0a2 -r 6ab17d8b5558 db_schema/lada_data.sql --- a/db_schema/lada_data.sql Fri Apr 29 16:40:26 2016 +0200 +++ b/db_schema/lada_data.sql Wed May 04 08:07:31 2016 +0200 @@ -25,70 +25,70 @@ 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; 727 t 06 06112 06112 0124 2 1 1 N41 2016-03-07 12:40:59+01 2016-03-07 12:40:59+01 \N 2016-03-07 12:41:20 \N 1 \N \N \N 2016-03-17 09:19:04.94469 724 t 11 11010 11010 123456789 2 1 1 D: 08 01 00 00 00 00 00 00 00 00 00 00 Deponie A11 2016-03-07 08:33:04+01 2016-03-07 08:33:04+01 \N 2016-03-07 08:35:29.318 \N 1 \N \N \N 2016-03-17 09:19:04.94469 -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 10303 2012-01-01 00:00:00 2012-01-31 21:59:59 2016-03-17 09:19:04.94469 +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 728 t 12 12020 12020 121212 2 1 1 D: 02 01 01 00 00 02 00 00 00 00 00 14 Grünfutter F11 2016-01-01 14:55:00+01 2016-02-01 14:55:00+01 \N 2016-03-07 14:58:10 \N 3 \N \N \N 2016-03-17 09:19:04.94469 729 t 12 12010 12010 123123123 2 1 1 D: 08 01 00 00 00 00 00 00 00 00 00 00 Abwasser A11 2016-03-06 15:38:00+01 \N \N 2016-03-07 15:41:49 \N \N \N \N \N 2016-03-17 09:19:04.94469 725 t 11 11010 11010 1234567 2 1 1 D: 08 01 01 00 00 00 00 00 00 00 00 00 A11 2016-03-01 11:19:00+01 2016-03-07 11:19:56+01 \N 2016-03-08 12:34:33.653 \N \N \N \N \N 2016-03-17 09:19:04.94469 731 f 11 11010 11010 \N 2 \N 3 D: 50 90 01 06 02 05 00 00 00 00 00 00 \N N81 \N \N \N \N \N \N \N \N \N 2016-03-02 12:43:00 2016-03-31 12:43:31.984 2016-03-17 09:19:04.94469 733 f 11 11010 11010 \N 2 \N 3 D: 50 90 01 06 02 05 00 00 00 00 00 00 \N N81 \N \N \N \N \N \N \N \N \N 2016-05-01 12:43:00 2016-05-30 12:43:31.984 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 18607 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 18319 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 13219 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 13218 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 7053 2012-01-09 00:00:00 2012-01-15 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 726 t 06 06010 06010 9876 2 1 9 D: 01 24 01 03 05 00 00 00 00 00 00 00 N25 2016-03-01 11:30:00+01 2016-03-02 11:30:00+01 \N 2016-03-07 11:52:22.289 \N 13 \N \N \N 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 3626 2012-01-23 00:00:00 2012-01-29 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 730 t 12 12010 12010 gro-m1234-1 2 1 1 A11 2016-03-04 15:00:00+01 \N \N 2016-03-07 15:42:05 \N \N \N \N \N 2016-03-17 09:19:04.94469 732 f 11 11010 11010 \N 2 \N 3 D: 50 90 01 06 02 05 00 00 00 00 00 00 \N N81 \N \N \N \N \N \N \N \N \N 2016-04-01 12:43:00 2016-04-30 12:43:31.984 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 13211 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 7107 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 18312 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 13187 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 13189 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 3558 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 3580 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 3474 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 3513 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 13165 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 25399 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 13198 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 13197 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 3564 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 13191 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 7051 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 7095 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 3746 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 3749 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 3755 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 3716 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 3678 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 3676 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 7086 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 3734 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 3730 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 7089 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 7083 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 7077 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 7101 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 3782 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 3775 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 3797 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 3796 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 3798 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 3792 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 3710 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 12671 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 7063 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 37464 2012-06-01 00:00:00 2012-06-30 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 7069 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 7057 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 3801 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 3786 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 18313 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 18310 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 3582 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 10786 2012-04-01 00:00:00 2012-06-30 21:59:59 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 \. diff -r 690b6506e0a2 -r 6ab17d8b5558 db_schema/setup-db.sh --- a/db_schema/setup-db.sh Fri Apr 29 16:40:26 2016 +0200 +++ b/db_schema/setup-db.sh Wed May 04 08:07:31 2016 +0200 @@ -2,7 +2,7 @@ DIR=`dirname $0` ROLE_NAME=${1:-lada} -echo "DROLE_NAME = $ROLE_NAME=" +echo "DROLE_NAME = $ROLE_NAME" ROLE_PW=${2:-$ROLE_NAME} echo "ROLE_PW = $ROLE_PW" DB_NAME=${3:-$ROLE_NAME} @@ -14,13 +14,12 @@ DB_CONNECT_STRING="$DB_CONNECT_STRING -p $DB_PORT" fi DB_CONNECT_STRING="$DB_CONNECT_STRING -U postgres" -echo "DB_CONNECT_STRING = $DB_CONNECT_STRING" +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 echo create user $ROLE_NAME psql $DB_CONNECT_STRING --command "CREATE USER $ROLE_NAME PASSWORD '$ROLE_PW';" fi -exit if psql -h test-pgsql1-fr.lab.bfs.de -U postgres -l | grep -q "^ $DB_NAME " ; then echo drop db $DB_NAME @@ -30,7 +29,6 @@ echo create db $DB_NAME psql $DB_CONNECT_STRING --command \ "CREATE DATABASE $DB_NAME WITH OWNER = $ROLE_NAME ENCODING = 'UTF8'" -exit echo create postgis extention psql $DB_CONNECT_STRING -d $DB_NAME --command \