Mercurial > lada > lada-server
diff db_schema/stammdaten_schema.sql @ 1221:59b0e54426d4
Use NULL instead of '-' for missing values.
This way missing values can be found and processed in the usual manner.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 09 Dec 2016 14:40:42 +0100 |
| parents | aed3332cfacc |
| children | f8df0eae09e4 |
line wrap: on
line diff
--- a/db_schema/stammdaten_schema.sql Fri Dec 09 12:26:10 2016 +0100 +++ b/db_schema/stammdaten_schema.sql Fri Dec 09 14:40:42 2016 +0100 @@ -141,7 +141,7 @@ id serial PRIMARY KEY, staat character varying(50) NOT NULL, hkl_id smallint NOT NULL, - staat_iso character varying(2) NOT NULL, + staat_iso character varying(2), staat_kurz character varying(5), eu character(1) DEFAULT NULL::bpchar, koord_x_extern character varying(22),