Mercurial > lada > lada-server
diff db_schema/lada_schema.sql @ 1215:6e393b614edf
The referencing column does not need to be wider than what it refereces.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Thu, 08 Dec 2016 15:23:55 +0100 |
| parents | 4ee336c65ab3 |
| children | 9dfb52db6a0f |
line wrap: on
line diff
--- a/db_schema/lada_schema.sql Thu Dec 08 14:59:02 2016 +0100 +++ b/db_schema/lada_schema.sql Thu Dec 08 15:23:55 2016 +0100 @@ -275,7 +275,7 @@ CREATE TABLE ortszuordnung ( id serial PRIMARY KEY, probe_id integer NOT NULL REFERENCES probe ON DELETE CASCADE, - ort_id bigint NOT NULL REFERENCES stammdaten.ort, + ort_id integer NOT NULL REFERENCES stammdaten.ort, ortszuordnung_typ character varying(1) REFERENCES stammdaten.ortszuordnung_typ, ortszusatztext character varying(100), letzte_aenderung timestamp without time zone DEFAULT now(),