--- a/backend/doc/schema/postgresql-sinfo-uinfo.sql	Fri Apr 27 11:34:04 2018 +0200
+++ b/backend/doc/schema/postgresql-sinfo-uinfo.sql	Fri Apr 27 17:35:12 2018 +0200
@@ -9,20 +9,40 @@
 
 --Add new columns bed_height.sounding_width_info and bed_height.comment
 
-ALTER TABLE bed_height ADD COLUMN sounding_width_info VARCHAR(256);
+ALTER TABLE bed_height
+  ADD sounding_width_info VARCHAR(256),
+  ADD "comment" VARCHAR(256);
 COMMENT ON COLUMN bed_height.sounding_width_info IS 'File header line info "ausgewertete Peilbreite"' ;
-
-ALTER TABLE bed_height ADD COLUMN "comment" VARCHAR(256);
 COMMENT ON COLUMN bed_height."comment" IS 'File header line info "weitere Bemerkungen"' ;
 
 
 --Add new columns bed_height_values.min_height (Talweg) and bed_height_values.max_height (Kammlage) (same type as existing height column)
 
-ALTER TABLE bed_height_values ADD COLUMN min_height NUMERIC;
+ALTER TABLE bed_height_values
+  ADD min_height NUMERIC,
+  ADD max_height NUMERIC,
+  ADD height01 NUMERIC,
+  ADD height02 NUMERIC,
+  ADD height03 NUMERIC,
+  ADD height04 NUMERIC,
+  ADD height05 NUMERIC,
+  ADD height06 NUMERIC,
+  ADD height07 NUMERIC,
+  ADD height08 NUMERIC,
+  ADD height09 NUMERIC,
+  ADD height10 NUMERIC;
 COMMENT ON COLUMN bed_height_values.min_height IS 'Minimum bed height (Talweg) in m' ;
-
-ALTER TABLE bed_height_values ADD COLUMN max_height NUMERIC;
 COMMENT ON COLUMN bed_height_values.max_height IS 'Maximum bed height (Kammlage) in m' ;
+COMMENT ON COLUMN bed_height_values.height01 IS 'Bed height of section 1 in m' ;
+COMMENT ON COLUMN bed_height_values.height02 IS 'Bed height of section 2 in m' ;
+COMMENT ON COLUMN bed_height_values.height03 IS 'Bed height of section 3 in m' ;
+COMMENT ON COLUMN bed_height_values.height04 IS 'Bed height of section 4 in m' ;
+COMMENT ON COLUMN bed_height_values.height05 IS 'Bed height of section 5 in m' ;
+COMMENT ON COLUMN bed_height_values.height06 IS 'Bed height of section 6 in m' ;
+COMMENT ON COLUMN bed_height_values.height07 IS 'Bed height of section 7 in m' ;
+COMMENT ON COLUMN bed_height_values.height08 IS 'Bed height of section 8 in m' ;
+COMMENT ON COLUMN bed_height_values.height09 IS 'Bed height of section 9 in m' ;
+COMMENT ON COLUMN bed_height_values.height10 IS 'Bed height of section 10 in m' ;
 
 
 --Bed mobility
@@ -185,6 +205,7 @@
     day  DATE,
     kmrange_info  VARCHAR(32),
     filename  VARCHAR(256) NOT NULL,
+    groupname  VARCHAR(32) NOT NULL CHECK(groupname IN ('messung','berechnung')),
     sounding_info  VARCHAR(64),
     evaluation_by  VARCHAR(256),
     "comment"  VARCHAR(256)
@@ -193,6 +214,7 @@
 COMMENT ON COLUMN tkh.day IS 'File header line info "Datum"' ;
 COMMENT ON COLUMN tkh.kmrange_info IS 'File header line info "Strecke"' ;
 COMMENT ON COLUMN tkh.filename IS 'Name without type extension of the imported file' ;
+COMMENT ON COLUMN tkh.groupname IS 'Group the file belongs to' ;
 COMMENT ON COLUMN tkh.sounding_info IS 'File header line info "Peilung"' ;
 COMMENT ON COLUMN tkh.evaluation_by IS 'File header line info "Auswerter"' ;
 COMMENT ON COLUMN tkh."comment" IS 'File header line info "weitere Bemerkungen"' ;
@@ -287,6 +309,7 @@
     curr_glw  VARCHAR(64) NOT NULL,
     old_glw  VARCHAR(64) NOT NULL,
     filename  VARCHAR(256) NOT NULL,
+    groupname  VARCHAR(32) NOT NULL CHECK(groupname IN ('aktuell','etappe')),
     "comment"  VARCHAR(256)
 );
 COMMENT ON TABLE depth_evolution IS 'Longitudinal section of the evolution of the flow depth of a river' ;
@@ -298,6 +321,7 @@
 COMMENT ON COLUMN depth_evolution.curr_glw IS 'File header line info "Aktuelle Wasserspiegellage"' ;
 COMMENT ON COLUMN depth_evolution.old_glw IS 'File header line info "Historische Wasserspiegellage"' ;
 COMMENT ON COLUMN depth_evolution.filename IS 'Name without type extension of the imported file' ;
+COMMENT ON COLUMN depth_evolution.groupname IS 'Group the file belongs to' ;
 COMMENT ON COLUMN depth_evolution."comment" IS 'File header line info "weitere Bemerkungen"' ;
 
 CREATE SEQUENCE DEPTH_EVOLUTION_ID_SEQ ;