changeset 173:8e2f2ddc507f

Fixed wrong spelled column references in foreign keys introduces with last change. flys-backend/trunk@1465 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Mon, 14 Mar 2011 15:40:14 +0000 (2011-03-14)
parents 605320b7df94
children 249390dd24e7
files flys-backend/ChangeLog flys-backend/doc/schema/postgresql.sql
diffstat 2 files changed, 8 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- 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
--- 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)

http://dive4elements.wald.intevation.org