Mercurial > lada > lada-server
changeset 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 | 73ad827faa81 |
| files | db_schema/stammdaten_data_staat.sql db_schema/stammdaten_schema.sql |
| diffstat | 2 files changed, 5 insertions(+), 5 deletions(-) [+] |
line wrap: on
line diff
--- a/db_schema/stammdaten_data_staat.sql Fri Dec 09 14:47:13 2016 +0100 +++ b/db_schema/stammdaten_data_staat.sql Fri Dec 09 14:57:17 2016 +0100 @@ -61,7 +61,7 @@ 681 Montenegro 170 ME MNE 0 19,216667 42,766667 4 682 Serbien 171 RS SB 0 20,933333 43,95 4 461 Pakistan 461 PK PK 0 73,060547 33,718151 4 -465 Taiwan 465 TW RC 0 121,506729 25,035091 4 +465 Taiwan 465 TW TW 0 121,506729 25,035091 4 467 Korea, Republik 467 KR ROK 0 126,935249 37,542351 4 472 Saudi-Arabien 472 SA KSA 0 46,77 24,65 4 475 Syrien 475 SY SYR 0 36,313454 33,519302 4
--- 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),