Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-spatial.sql @ 5409:8b29a94ebdd8
SCHEMA CHANGE: add table for flood marks and missing DROPs for jetties
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Mon, 25 Mar 2013 17:51:33 +0100 |
| parents | e65fee5ea98a |
| children | 1488227b97b7 |
comparison
equal
deleted
inserted
replaced
| 5408:91f5908c472a | 5409:8b29a94ebdd8 |
|---|---|
| 329 z FLOAT8 | 329 z FLOAT8 |
| 330 ); | 330 ); |
| 331 SELECT AddGeometryColumn('jetties','geom',31467,'POINT',2); | 331 SELECT AddGeometryColumn('jetties','geom',31467,'POINT',2); |
| 332 ALTER TABLE jetties ALTER COLUMN id SET DEFAULT NEXTVAL('JETTIES_ID_SEQ'); | 332 ALTER TABLE jetties ALTER COLUMN id SET DEFAULT NEXTVAL('JETTIES_ID_SEQ'); |
| 333 | 333 |
| 334 CREATE SEQUENCE FLOOD_MARKS_ID_SEQ; | |
| 335 CREATE TABLE flood_marks ( | |
| 336 id int PRIMARY KEY NOT NULL, | |
| 337 river_id int REFERENCES rivers(id) ON DELETE CASCADE, | |
| 338 path VARCHAR(256), | |
| 339 km FLOAT8, | |
| 340 z FLOAT8, | |
| 341 location VARCHAR(64), | |
| 342 year int | |
| 343 ); | |
| 344 SELECT AddGeometryColumn('flood_marks','geom',31467,'POINT',2); | |
| 345 ALTER TABLE flood_marks ALTER COLUMN id SET DEFAULT NEXTVAL('FLOOD_MARKS_ID_SEQ'); | |
| 334 | 346 |
| 335 COMMIT; | 347 COMMIT; |