Mercurial > lada > lada-server
diff db_schema/stammdaten_schema.sql @ 1223:9b8b18c00804
Make all state identifiers unique.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Fri, 09 Dec 2016 14:57:17 +0100 |
parents | f8df0eae09e4 |
children | f094aca05cf2 |
line wrap: on
line diff
--- a/db_schema/stammdaten_schema.sql Fri Dec 09 14:47:13 2016 +0100 +++ b/db_schema/stammdaten_schema.sql Fri Dec 09 14:57:17 2016 +0100 @@ -139,10 +139,10 @@ CREATE TABLE staat ( id serial PRIMARY KEY, - staat character varying(50) NOT NULL, - hkl_id smallint NOT NULL, - staat_iso character varying(2), - staat_kurz character varying(5), + staat character varying(50) NOT NULL UNIQUE, + hkl_id smallint NOT NULL UNIQUE, + staat_iso character varying(2) UNIQUE, + staat_kurz character varying(5) UNIQUE, eu boolean, koord_x_extern character varying(22), koord_y_extern character varying(22),