Mercurial > lada > lada-server
diff db_schema/lada_schema.sql @ 914:54e83373bfae
We need a wider range to allow arbitrary input formated +-9.99e+-99
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 08 Apr 2016 17:17:06 +0200 |
| parents | 56c9fb1d37c8 |
| children | 34c04b0557ac 9121d99a471e |
line wrap: on
line diff
--- a/db_schema/lada_schema.sql Fri Apr 08 12:32:34 2016 +0200 +++ b/db_schema/lada_schema.sql Fri Apr 08 17:17:06 2016 +0200 @@ -302,9 +302,9 @@ messungs_id integer NOT NULL, messgroesse_id integer NOT NULL, messwert_nwg character varying(1), - messwert real NOT NULL, + messwert double precision NOT NULL, messfehler real, - nwg_zu_messwert real, + nwg_zu_messwert double precision, meh_id smallint NOT NULL, grenzwertueberschreitung boolean DEFAULT false, letzte_aenderung timestamp without time zone DEFAULT now() @@ -495,10 +495,10 @@ id integer DEFAULT nextval('zusatz_wert_id_seq'::regclass) NOT NULL, probe_id integer NOT NULL, pzs_id character varying(3) NOT NULL, - messwert_pzs real, + messwert_pzs double precision, messfehler real, letzte_aenderung timestamp without time zone DEFAULT now(), - nwg_zu_messwert real + nwg_zu_messwert double precision );