Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-spatial.sql @ 5513:ef3517905e6e
Add not null and default for hydr_boundary classifiers
author | Andre Heinecke <aheinecke@intevation.de> |
---|---|
date | Thu, 28 Mar 2013 15:31:34 +0100 |
parents | 1488227b97b7 |
children | 4c4fed23693f |
comparison
equal
deleted
inserted
replaced
5512:b91ffd97edc8 | 5513:ef3517905e6e |
---|---|
275 CREATE SEQUENCE HYDR_BOUNDARIES_ID_SEQ; | 275 CREATE SEQUENCE HYDR_BOUNDARIES_ID_SEQ; |
276 CREATE TABLE hydr_boundaries ( | 276 CREATE TABLE hydr_boundaries ( |
277 id int PRIMARY KEY NOT NULL, | 277 id int PRIMARY KEY NOT NULL, |
278 river_id int REFERENCES rivers(id) ON DELETE CASCADE, | 278 river_id int REFERENCES rivers(id) ON DELETE CASCADE, |
279 name VARCHAR(255), | 279 name VARCHAR(255), |
280 kind int REFERENCES boundary_kinds(id), | 280 kind int REFERENCES boundary_kinds(id) NOT NULL DEFAULT 0, |
281 sectie int REFERENCES sectie_kinds(id), | 281 sectie int REFERENCES sectie_kinds(id) NOT NULL DEFAULT 0, |
282 sobek int REFERENCES sobek_kinds(id), | 282 sobek int REFERENCES sobek_kinds(id) NOT NULL DEFAULT 0, |
283 path VARCHAR(256) | 283 path VARCHAR(256) |
284 ); | 284 ); |
285 SELECT AddGeometryColumn('hydr_boundaries','geom',31467,'MULTILINESTRING',3); | 285 SELECT AddGeometryColumn('hydr_boundaries','geom',31467,'MULTILINESTRING',3); |
286 ALTER TABLE hydr_boundaries ALTER COLUMN id SET DEFAULT NEXTVAL('HYDR_BOUNDARIES_ID_SEQ'); | 286 ALTER TABLE hydr_boundaries ALTER COLUMN id SET DEFAULT NEXTVAL('HYDR_BOUNDARIES_ID_SEQ'); |
287 | 287 |
289 CREATE SEQUENCE HYDR_BOUNDARIES_POLY_ID_SEQ; | 289 CREATE SEQUENCE HYDR_BOUNDARIES_POLY_ID_SEQ; |
290 CREATE TABLE hydr_boundaries_poly ( | 290 CREATE TABLE hydr_boundaries_poly ( |
291 id int PRIMARY KEY NOT NULL, | 291 id int PRIMARY KEY NOT NULL, |
292 river_id int REFERENCES rivers(id) ON DELETE CASCADE, | 292 river_id int REFERENCES rivers(id) ON DELETE CASCADE, |
293 name VARCHAR(255), | 293 name VARCHAR(255), |
294 kind int REFERENCES boundary_kinds(id), | 294 kind int REFERENCES boundary_kinds(id) NOT NULL DEFAULT 0, |
295 sectie int REFERENCES sectie_kinds(id), | 295 sectie int REFERENCES sectie_kinds(id) NOT NULL DEFAULT 0, |
296 sobek int REFERENCES sobek_kinds(id), | 296 sobek int REFERENCES sobek_kinds(id) NOT NULL DEFAULT 0, |
297 path VARCHAR(256) | 297 path VARCHAR(256) |
298 ); | 298 ); |
299 SELECT AddGeometryColumn('hydr_boundaries_poly','geom',31467,'MULTIPOLYGON',3); | 299 SELECT AddGeometryColumn('hydr_boundaries_poly','geom',31467,'MULTIPOLYGON',3); |
300 ALTER TABLE hydr_boundaries_poly ALTER COLUMN id SET DEFAULT NEXTVAL('HYDR_BOUNDARIES_POLY_ID_SEQ'); | 300 ALTER TABLE hydr_boundaries_poly ALTER COLUMN id SET DEFAULT NEXTVAL('HYDR_BOUNDARIES_POLY_ID_SEQ'); |
301 | 301 |