Mercurial > dive4elements > river
comparison backend/doc/schema/postgresql-spatial.sql @ 5886:6a63456b99d9
Schema change, importer, i18n: additional field for federal state stations
| author | Tom Gottfried <tom.gottfried@intevation.de> |
|---|---|
| date | Tue, 30 Apr 2013 19:27:15 +0200 |
| parents | 249b8766a178 |
| children | dcc7a6c8b92c |
comparison
equal
deleted
inserted
replaced
| 5885:09d9c14145a3 | 5886:6a63456b99d9 |
|---|---|
| 26 CREATE SEQUENCE RIVER_AXES_KM_ID_SEQ; | 26 CREATE SEQUENCE RIVER_AXES_KM_ID_SEQ; |
| 27 CREATE TABLE river_axes_km ( | 27 CREATE TABLE river_axes_km ( |
| 28 id int PRIMARY KEY NOT NULL, | 28 id int PRIMARY KEY NOT NULL, |
| 29 river_id int REFERENCES rivers(id) ON DELETE CASCADE, | 29 river_id int REFERENCES rivers(id) ON DELETE CASCADE, |
| 30 km FLOAT8 NOT NULL, | 30 km FLOAT8 NOT NULL, |
| 31 fedstate_km FLOAT8, | |
| 31 name VARCHAR(64), | 32 name VARCHAR(64), |
| 32 path VARCHAR(256) | 33 path VARCHAR(256) |
| 33 ); | 34 ); |
| 34 SELECT AddGeometryColumn('river_axes_km', 'geom', 31467, 'POINT', 2); | 35 SELECT AddGeometryColumn('river_axes_km', 'geom', 31467, 'POINT', 2); |
| 35 ALTER TABLE river_axes_km ALTER COLUMN id SET DEFAULT NEXTVAL('RIVER_AXES_KM_ID_SEQ'); | 36 ALTER TABLE river_axes_km ALTER COLUMN id SET DEFAULT NEXTVAL('RIVER_AXES_KM_ID_SEQ'); |