# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1305103454 0
# Node ID ce9c6f05f46460f616a57a90c7363876ca5365b8
# Parent  ee693b8fbb5571fb318cb96ec4e3bb5f90c18158
Schema: Added a column which tells if a river counts its km up or downwards.



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

diff -r ee693b8fbb55 -r ce9c6f05f464 flys-backend/ChangeLog
--- a/flys-backend/ChangeLog	Tue May 10 17:31:10 2011 +0000
+++ b/flys-backend/ChangeLog	Wed May 11 08:44:14 2011 +0000
@@ -1,3 +1,14 @@
+2011-05-10	Sascha L. Teichmann	<sascha.teichmann@intevation.de>
+
+	* doc/schema/postgresql.sql: Added a column which tells
+	  if a river counts its km up or downwards.
+	  To update existing databases:
+
+	    ALTER TABLE rivers ADD COLUMN km_up BOOLEAN NOT NULL DEFAULT true;
+
+	* src/main/java/de/intevation/flys/model/River.java:
+	  Adjust Hibernate mapping of new column.
+
 2011-05-10	Sascha L. Teichmann	<sascha.teichmann@intevation.de>
 
 	* src/main/java/de/intevation/flys/importer/AtFileParser.java:
diff -r ee693b8fbb55 -r ce9c6f05f464 flys-backend/doc/schema/postgresql.sql
--- a/flys-backend/doc/schema/postgresql.sql	Tue May 10 17:31:10 2011 +0000
+++ b/flys-backend/doc/schema/postgresql.sql	Wed May 11 08:44:14 2011 +0000
@@ -4,8 +4,9 @@
 CREATE SEQUENCE RIVERS_ID_SEQ;
 
 CREATE TABLE rivers (
-    id   int PRIMARY KEY NOT NULL,
-    name VARCHAR(256)    NOT NULL UNIQUE
+    id    int PRIMARY KEY NOT NULL,
+    name  VARCHAR(256)    NOT NULL UNIQUE,
+    km_up BOOLEAN         NOT NULL DEFAULT true
 );
 
 -- Bruecke, Haefen, etc.
diff -r ee693b8fbb55 -r ce9c6f05f464 flys-backend/src/main/java/de/intevation/flys/model/River.java
--- a/flys-backend/src/main/java/de/intevation/flys/model/River.java	Tue May 10 17:31:10 2011 +0000
+++ b/flys-backend/src/main/java/de/intevation/flys/model/River.java	Wed May 11 08:44:14 2011 +0000
@@ -31,6 +31,8 @@
 
     private String  name;
 
+    private boolean kmUp;
+
     private List<Gauge> gauges;
 
     @Id
@@ -59,6 +61,15 @@
         this.name = name;
     }
 
+    @Column(name = "km_up")
+    public boolean getKmUp() {
+        return kmUp;
+    }
+
+    public void setKmUp(boolean kmUp) {
+        this.kmUp = kmUp;
+    }
+
     public River() {
     }