# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1300117214 0
# Node ID 8e2f2ddc507ff71b570d8e7be4d9323725c8de21
# Parent  605320b7df9437fdabf7132c46c7d4eedf539f67
Fixed wrong spelled column references in foreign keys introduces with last change.


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

diff -r 605320b7df94 -r 8e2f2ddc507f flys-backend/ChangeLog
--- a/flys-backend/ChangeLog	Mon Mar 14 15:29:00 2011 +0000
+++ b/flys-backend/ChangeLog	Mon Mar 14 15:40:14 2011 +0000
@@ -1,3 +1,9 @@
+2011-03-14	Sascha L. Teichmann	<sascha.teichmann@intevation.de>
+
+	* doc/schema/postgresql.sql: Fixed wrong spelled 
+	  column references in foreign keys introduces with
+	  last change.
+
 2011-03-14	Sascha L. Teichmann	<sascha.teichmann@intevation.de>
 
 	* src/main/java/de/intevation/flys/model/*.java: Added
diff -r 605320b7df94 -r 8e2f2ddc507f flys-backend/doc/schema/postgresql.sql
--- a/flys-backend/doc/schema/postgresql.sql	Mon Mar 14 15:29:00 2011 +0000
+++ b/flys-backend/doc/schema/postgresql.sql	Mon Mar 14 15:40:14 2011 +0000
@@ -149,7 +149,7 @@
 
 CREATE TABLE wst_columns (
     id          int PRIMARY KEY NOT NULL,
-    wst_id      int NOT NULL REFERENCES wst(id),
+    wst_id      int NOT NULL REFERENCES wsts(id),
     name        VARCHAR(256) NOT NULL,
     description VARCHAR,
 
@@ -185,7 +185,7 @@
 
 CREATE TABLE wst_column_q_ranges (
     id             int PRIMARY KEY NOT NULL,
-    wst_column_id  int NOT NULL REFERENCES wst_column(id),
+    wst_column_id  int NOT NULL REFERENCES wst_columns(id),
     wst_q_range_id int NOT NULL REFERENCES wst_q_ranges(id),
 
     UNIQUE (wst_column_id, wst_q_range_id)