Mercurial > dive4elements > river
comparison backend/doc/schema/postgresql-spatial.sql @ 7352:c6825778de1f
Merged double-precision branch.
| author | Sascha L. Teichmann <teichmann@intevation.de> |
|---|---|
| date | Wed, 16 Oct 2013 13:03:13 +0200 |
| parents | dcc7a6c8b92c |
| children | f4e32ac4e55c |
comparison
equal
deleted
inserted
replaced
| 7350:760ea7f08455 | 7352:c6825778de1f |
|---|---|
| 121 CREATE SEQUENCE DEM_ID_SEQ; | 121 CREATE SEQUENCE DEM_ID_SEQ; |
| 122 CREATE TABLE dem ( | 122 CREATE TABLE dem ( |
| 123 id int PRIMARY KEY NOT NULL, | 123 id int PRIMARY KEY NOT NULL, |
| 124 river_id int REFERENCES rivers(id) ON DELETE CASCADE, | 124 river_id int REFERENCES rivers(id) ON DELETE CASCADE, |
| 125 name VARCHAR(64), | 125 name VARCHAR(64), |
| 126 range_id INT REFERENCES ranges(id), | 126 range_id INT REFERENCES ranges(id) ON DELETE CASCADE, |
| 127 time_interval_id INT REFERENCES time_intervals(id), | 127 time_interval_id INT REFERENCES time_intervals(id), |
| 128 projection VARCHAR(32), | 128 projection VARCHAR(32), |
| 129 srid int NOT NULL, | 129 srid int NOT NULL, |
| 130 elevation_state VARCHAR(32), | 130 elevation_state VARCHAR(32), |
| 131 format VARCHAR(32), | 131 format VARCHAR(32), |