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 |