Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-spatial.sql @ 5289:f6478773a5bb
postgresql-spatial.sql: Fixed table definition.
| author | Felix Wolfsteller <felix.wolfsteller@intevation.de> |
|---|---|
| date | Thu, 14 Mar 2013 12:24:29 +0100 |
| parents | 170f514a4f29 |
| children | 3dc4c2798212 |
comparison
equal
deleted
inserted
replaced
| 5288:b0f14ff573d7 | 5289:f6478773a5bb |
|---|---|
| 110 CREATE TABLE dem ( | 110 CREATE TABLE dem ( |
| 111 id int PRIMARY KEY NOT NULL, | 111 id int PRIMARY KEY NOT NULL, |
| 112 river_id int REFERENCES rivers(id) ON DELETE CASCADE, | 112 river_id int REFERENCES rivers(id) ON DELETE CASCADE, |
| 113 -- XXX Should we use the ranges table instead? | 113 -- XXX Should we use the ranges table instead? |
| 114 name VARCHAR(64), | 114 name VARCHAR(64), |
| 115 range_id INT REFERENCES ranges(id); | 115 range_id INT REFERENCES ranges(id), |
| 116 time_interval_id INT REFERENCES time_intervals(id); | 116 time_interval_id int REFERENCES time_intervals(id), |
| 117 projection VARCHAR(32), | 117 projection VARCHAR(32), |
| 118 srid int NOT NULL, | 118 srid int NOT NULL, |
| 119 elevation_state VARCHAR(32), | 119 elevation_state VARCHAR(32), |
| 120 format VARCHAR(32), | 120 format VARCHAR(32), |
| 121 border_break BOOLEAN NOT NULL DEFAULT FALSE, | 121 border_break BOOLEAN NOT NULL DEFAULT FALSE, |