# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1347468698 0
# Node ID 61195d14b844c7cb962ba529b0b862115a361ebc
# Parent  f210432f438329ba56c6c552dbebfd7e5d693344
FLYS backend: Fixed postgresql scheme.

flys-backend/trunk@5445 c6561f87-3c4e-4783-a992-168aeb5c3f6f

diff -r f210432f4383 -r 61195d14b844 flys-backend/ChangeLog
--- 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:
diff -r f210432f4383 -r 61195d14b844 flys-backend/doc/schema/postgresql.sql
--- 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;