Mercurial > dive4elements > river
comparison backend/doc/schema/postgresql-spatial.sql @ 7737:f4e32ac4e55c
This was obsolete since r5294.
| author | Tom Gottfried <tom.gottfried@intevation.de> |
|---|---|
| date | Fri, 31 Jan 2014 19:57:35 +0100 |
| parents | dcc7a6c8b92c |
| children | cc53aae06303 |
comparison
equal
deleted
inserted
replaced
| 7736:714fda61b006 | 7737:f4e32ac4e55c |
|---|---|
| 242 waterbody varchar(64), | 242 waterbody varchar(64), |
| 243 path VARCHAR(256), | 243 path VARCHAR(256), |
| 244 source varchar(64) | 244 source varchar(64) |
| 245 ); | 245 ); |
| 246 SELECT AddGeometryColumn('floodmaps', 'geom', 31467, 'MULTIPOLYGON', 2); | 246 SELECT AddGeometryColumn('floodmaps', 'geom', 31467, 'MULTIPOLYGON', 2); |
| 247 ALTER TABLE floodmaps DROP CONSTRAINT enforce_geotype_geom; | |
| 248 ALTER TABLE floodmaps ADD CONSTRAINT enforce_geotype_geom CHECK (geometrytype(geom) = 'POLYGON'::text OR geometrytype(geom) = 'MULTIPOLYGON'::text); | |
| 249 ALTER TABLE floodmaps ALTER COLUMN id SET DEFAULT NEXTVAL('FLOODMAPS_ID_SEQ'); | 247 ALTER TABLE floodmaps ALTER COLUMN id SET DEFAULT NEXTVAL('FLOODMAPS_ID_SEQ'); |
| 250 | 248 |
| 251 CREATE TABLE sectie_kinds ( | 249 CREATE TABLE sectie_kinds ( |
| 252 id int PRIMARY KEY NOT NULL, | 250 id int PRIMARY KEY NOT NULL, |
| 253 name VARCHAR(64) NOT NULL | 251 name VARCHAR(64) NOT NULL |