diff db_schema/lada_data.sql @ 991:ce1ec3cbde54

Make ID for Messregime an integer. Using VARCHAR(1) has drawbacks such as an empty string being a valid value.
author Tom Gottfried <tom@intevation.de>
date Fri, 01 Jul 2016 17:36:06 +0200
parents 807626952aa8
children 186d602e031a
line wrap: on
line diff
--- a/db_schema/lada_data.sql	Fri Jul 01 16:55:16 2016 +0200
+++ b/db_schema/lada_data.sql	Fri Jul 01 17:36:06 2016 +0200
@@ -30,7 +30,7 @@
 
 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
+409	f	12	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	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
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)