# HG changeset patch
# User mschaefer
# Date 1522736956 -7200
# Node ID 5b23efe99e80a540adbc3e54eeda26423241c0a4
# Parent  f89fb9e9abad19f5b3c86b9f144a1359a56c2db6
Add two bed_height meta info columns and bed_height_values min/max_height

diff -r f89fb9e9abad -r 5b23efe99e80 backend/doc/schema/postgresql-alter-bed_height.sql
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/backend/doc/schema/postgresql-alter-bed_height.sql	Tue Apr 03 08:29:16 2018 +0200
@@ -0,0 +1,22 @@
+BEGIN;
+
+
+--Add further bed height file header info columns
+
+ALTER TABLE bed_height ADD COLUMN sounding_width_info VARCHAR(32);
+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 bed_height_values columns for min height (Talweg) and max height (Kammlage) (same type as existing value column)
+
+ALTER TABLE bed_height_values ADD COLUMN min_height 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' ;
+
+
+COMMIT;