Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-spatial.sql @ 5623:0aaed46a88be
Schema change: Allow longer strings in fixpoints.hpgp
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Tue, 09 Apr 2013 19:07:20 +0200 |
parents | 4c4fed23693f |
children | b5553164fabf |
comparison
equal
deleted
inserted
replaced
5622:b28a6d05e969 | 5623:0aaed46a88be |
---|---|
86 id int PRIMARY KEY NOT NULL, | 86 id int PRIMARY KEY NOT NULL, |
87 river_id int REFERENCES rivers(id) ON DELETE CASCADE, | 87 river_id int REFERENCES rivers(id) ON DELETE CASCADE, |
88 x FLOAT8, | 88 x FLOAT8, |
89 y FLOAT8, | 89 y FLOAT8, |
90 km FLOAT8 NOT NULL, | 90 km FLOAT8 NOT NULL, |
91 HPGP VARCHAR(2), | 91 HPGP VARCHAR(64), |
92 name VARCHAR(64), | 92 name VARCHAR(64), |
93 path VARCHAR(256) | 93 path VARCHAR(256) |
94 ); | 94 ); |
95 SELECT AddGeometryColumn('fixpoints', 'geom', 31467, 'POINT', 2); | 95 SELECT AddGeometryColumn('fixpoints', 'geom', 31467, 'POINT', 2); |
96 ALTER TABLE fixpoints ALTER COLUMN id SET DEFAULT NEXTVAL('FIXPOINTS_ID_SEQ'); | 96 ALTER TABLE fixpoints ALTER COLUMN id SET DEFAULT NEXTVAL('FIXPOINTS_ID_SEQ'); |