Mercurial > lada > lada-server
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