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