Mercurial > dive4elements > river
comparison backend/doc/schema/postgresql-spatial.sql @ 8466:cc53aae06303
Gauge locations are obsolete since a long time.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Wed, 05 Nov 2014 13:04:53 +0100 |
| parents | f4e32ac4e55c |
| children | 71b17f731762 6824c447f5b0 |
comparison
equal
deleted
inserted
replaced
| 8465:2772a0fc7400 | 8466:cc53aae06303 |
|---|---|
| 298 ); | 298 ); |
| 299 SELECT AddGeometryColumn('hydr_boundaries_poly','geom',31467,'MULTIPOLYGON',3); | 299 SELECT AddGeometryColumn('hydr_boundaries_poly','geom',31467,'MULTIPOLYGON',3); |
| 300 ALTER TABLE hydr_boundaries_poly ALTER COLUMN id SET DEFAULT NEXTVAL('HYDR_BOUNDARIES_POLY_ID_SEQ'); | 300 ALTER TABLE hydr_boundaries_poly ALTER COLUMN id SET DEFAULT NEXTVAL('HYDR_BOUNDARIES_POLY_ID_SEQ'); |
| 301 | 301 |
| 302 | 302 |
| 303 CREATE SEQUENCE GAUGE_LOCATION_ID_SEQ; | |
| 304 CREATE TABLE gauge_location ( | |
| 305 id int PRIMARY KEY NOT NULL, | |
| 306 river_id int REFERENCES rivers(id) ON DELETE CASCADE, | |
| 307 name VARCHAR(255), | |
| 308 path VARCHAR(256) | |
| 309 ); | |
| 310 SELECT AddGeometryColumn('gauge_location','geom',31467,'POINT',2); | |
| 311 ALTER TABLE gauge_location ALTER COLUMN id SET DEFAULT NEXTVAL('GAUGE_LOCATION_ID_SEQ'); | |
| 312 | |
| 313 | |
| 314 CREATE TABLE jetty_kinds( | 303 CREATE TABLE jetty_kinds( |
| 315 id int PRIMARY KEY NOT NULL, | 304 id int PRIMARY KEY NOT NULL, |
| 316 name VARCHAR(64) | 305 name VARCHAR(64) |
| 317 ); | 306 ); |
| 318 INSERT INTO jetty_kinds VALUES (0, 'Buhnenkopf'); | 307 INSERT INTO jetty_kinds VALUES (0, 'Buhnenkopf'); |