# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1302881315 0
# Node ID f4afea9b753711a63c1620d3390ac502fcf42cfc
# Parent  b5ca22aae092f60e8510d6af0ad15f151c543aaa
Forget ',' in schema.

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

diff -r b5ca22aae092 -r f4afea9b7537 flys-backend/ChangeLog
--- a/flys-backend/ChangeLog	Fri Apr 15 14:30:54 2011 +0000
+++ b/flys-backend/ChangeLog	Fri Apr 15 15:28:35 2011 +0000
@@ -1,3 +1,7 @@
+2011-04-15	Sascha L. Teichmann	<sascha.teichmann@intevation.de>
+
+	* doc/schema/postgresql.sql: Forget ',' in schema.
+
 2011-04-15	Sascha L. Teichmann	<sascha.teichmann@intevation.de>
 
 	* src/main/java/de/intevation/flys/model/Wst.java (determineMinMaxQ): 
diff -r b5ca22aae092 -r f4afea9b7537 flys-backend/doc/schema/postgresql.sql
--- a/flys-backend/doc/schema/postgresql.sql	Fri Apr 15 14:30:54 2011 +0000
+++ b/flys-backend/doc/schema/postgresql.sql	Fri Apr 15 15:28:35 2011 +0000
@@ -114,7 +114,7 @@
 CREATE TABLE discharge_tables (
     id               int PRIMARY KEY NOT NULL,
     gauge_id         int NOT NULL REFERENCES gauges(id),
-    kind             int NOT NULL DEFAULT 0
+    kind             int NOT NULL DEFAULT 0,
     time_interval_id int REFERENCES time_intervals(id),
 
     -- TODO: better checks
@@ -140,7 +140,7 @@
     id          int PRIMARY KEY NOT NULL,
     river_id    int NOT NULL REFERENCES rivers(id),
     description VARCHAR(256) NOT NULL,
-    kind        int NOT NULL DEFAULT 0
+    kind        int NOT NULL DEFAULT 0,
     -- TODO: more meta infos
     UNIQUE (river_id, description)
 );