Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql.sql @ 5783:153456f84602
add missing constraints to Oracle Schema (issue426) and some cosmetics
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Mon, 22 Apr 2013 13:00:13 +0200 |
parents | 88cbe798cbab |
children |
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql.sql Mon Apr 22 12:11:55 2013 +0200 +++ b/flys-backend/doc/schema/postgresql.sql Mon Apr 22 13:00:13 2013 +0200 @@ -69,8 +69,8 @@ CREATE TABLE annotations ( id int PRIMARY KEY NOT NULL, - range_id int NOT NULL REFERENCES ranges(id) ON DELETE CASCADE, - attribute_id int NOT NULL REFERENCES attributes(id), + range_id int NOT NULL REFERENCES ranges(id) ON DELETE CASCADE, + attribute_id int NOT NULL REFERENCES attributes(id), position_id int REFERENCES positions(id), edge_id int REFERENCES edges(id), type_id int REFERENCES annotation_types(id)