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'); |