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 ); |