Mercurial > lada > lada-server
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 990:ff07474b65e0 | 991:ce1ec3cbde54 |
|---|---|
| 28 | 28 |
| 29 ALTER TABLE probe DISABLE TRIGGER ALL; | 29 ALTER TABLE probe DISABLE TRIGGER ALL; |
| 30 | 30 |
| 31 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; | 31 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; |
| 32 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 | 32 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 |
| 33 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 | 33 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 |
| 34 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 | 34 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 |
| 35 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 | 35 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 |
| 36 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 | 36 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 |
| 37 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 | 37 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 |
| 38 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 | 38 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 |