Mercurial > dive4elements > river
changeset 3796:61195d14b844
FLYS backend: Fixed postgresql scheme.
flys-backend/trunk@5445 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Wed, 12 Sep 2012 16:51:38 +0000 |
| parents | f210432f4383 |
| children | 0f99e9f1a2ca |
| files | flys-backend/ChangeLog flys-backend/doc/schema/postgresql.sql |
| diffstat | 2 files changed, 12 insertions(+), 5 deletions(-) [+] |
line wrap: on
line diff
--- a/flys-backend/ChangeLog Wed Sep 12 11:12:19 2012 +0000 +++ b/flys-backend/ChangeLog Wed Sep 12 16:51:38 2012 +0000 @@ -1,3 +1,9 @@ +2012-09-12 Sascha L. Teichmann <sascha.teichmann@intevation.de> + + * doc/schema/postgresql.sql: Indices on cross sections + were created too early (before the referenced tables + were created). + 2012-09-12 Björn Ricks <bjoern.ricks@intevation.de> * src/main/java/de/intevation/flys/model/River.java:
--- a/flys-backend/doc/schema/postgresql.sql Wed Sep 12 11:12:19 2012 +0000 +++ b/flys-backend/doc/schema/postgresql.sql Wed Sep 12 16:51:38 2012 +0000 @@ -280,12 +280,6 @@ description VARCHAR(256) ); --- Indices for faster access of the points -CREATE INDEX cross_section_lines_km_idx - ON cross_section_lines(km); -CREATE INDEX cross_section_points_line_idx - ON cross_section_points(cross_section_line_id); - CREATE SEQUENCE CROSS_SECTION_LINES_ID_SEQ; CREATE TABLE cross_section_lines ( @@ -306,6 +300,12 @@ UNIQUE (cross_section_line_id, col_pos) ); +-- Indices for faster access of the points +CREATE INDEX cross_section_lines_km_idx + ON cross_section_lines(km); +CREATE INDEX cross_section_points_line_idx + ON cross_section_points(cross_section_line_id); + -- Hydraulische Kenngroessen CREATE SEQUENCE HYKS_ID_SEQ;