Mercurial > lada > lada-server
comparison 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 |
comparison
equal
deleted
inserted
replaced
1222:f8df0eae09e4 | 1223:9b8b18c00804 |
---|---|
137 INSERT INTO betriebsart VALUES(2, 'Störfall-/Intensivbetrieb'); | 137 INSERT INTO betriebsart VALUES(2, 'Störfall-/Intensivbetrieb'); |
138 | 138 |
139 | 139 |
140 CREATE TABLE staat ( | 140 CREATE TABLE staat ( |
141 id serial PRIMARY KEY, | 141 id serial PRIMARY KEY, |
142 staat character varying(50) NOT NULL, | 142 staat character varying(50) NOT NULL UNIQUE, |
143 hkl_id smallint NOT NULL, | 143 hkl_id smallint NOT NULL UNIQUE, |
144 staat_iso character varying(2), | 144 staat_iso character varying(2) UNIQUE, |
145 staat_kurz character varying(5), | 145 staat_kurz character varying(5) UNIQUE, |
146 eu boolean, | 146 eu boolean, |
147 koord_x_extern character varying(22), | 147 koord_x_extern character varying(22), |
148 koord_y_extern character varying(22), | 148 koord_y_extern character varying(22), |
149 kda_id integer REFERENCES koordinaten_art | 149 kda_id integer REFERENCES koordinaten_art |
150 ); | 150 ); |