Mercurial > lada > lada-server
diff db_schema/stammdaten_schema.sql @ 1176:33dc7dc6b7bc
Removed NOT NULL constraint from stammdaten.ort.staat_id.
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Wed, 16 Nov 2016 15:57:14 +0100 |
| parents | 60b91dbb98cc |
| children | 612107caf961 |
line wrap: on
line diff
--- a/db_schema/stammdaten_schema.sql Wed Nov 16 15:56:43 2016 +0100 +++ b/db_schema/stammdaten_schema.sql Wed Nov 16 15:57:14 2016 +0100 @@ -440,7 +440,7 @@ netzbetreiber_id character varying(2) NOT NULL REFERENCES netz_betreiber, ort_id character varying(10) NOT NULL, langtext character varying(100) NOT NULL, - staat_id smallint NOT NULL REFERENCES staat, + staat_id smallint REFERENCES staat, gem_id character varying(8) REFERENCES verwaltungseinheit, unscharf character(1) DEFAULT NULL::bpchar, nuts_code character varying(10),