Mercurial > lada > lada-server
comparison db_schema/stammdaten_schema.sql @ 1249:f094aca05cf2
Avoid having to handle missing shapes.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 16 Dec 2016 16:18:37 +0100 |
| parents | 9b8b18c00804 |
| children | cb88ab44c2be |
comparison
equal
deleted
inserted
replaced
| 1248:3f7c22b0b888 | 1249:f094aca05cf2 |
|---|---|
| 165 ); | 165 ); |
| 166 | 166 |
| 167 CREATE TABLE verwaltungsgrenze ( | 167 CREATE TABLE verwaltungsgrenze ( |
| 168 id serial PRIMARY KEY, | 168 id serial PRIMARY KEY, |
| 169 gem_id character varying(8) NOT NULL REFERENCES verwaltungseinheit, | 169 gem_id character varying(8) NOT NULL REFERENCES verwaltungseinheit, |
| 170 shape public.geometry(MultiPolygon, 4326) | 170 shape public.geometry(MultiPolygon, 4326) NOT NULL |
| 171 ); | 171 ); |
| 172 CREATE INDEX verwaltungsgrenze_sp_idx ON verwaltungsgrenze USING gist (shape); | 172 CREATE INDEX verwaltungsgrenze_sp_idx ON verwaltungsgrenze USING gist (shape); |
| 173 | 173 |
| 174 CREATE TABLE netz_betreiber ( | 174 CREATE TABLE netz_betreiber ( |
| 175 id character varying(2) PRIMARY KEY, | 175 id character varying(2) PRIMARY KEY, |