Mercurial > dive4elements > river
changeset 8966:5b23efe99e80
Add two bed_height meta info columns and bed_height_values min/max_height
author | mschaefer |
---|---|
date | Tue, 03 Apr 2018 08:29:16 +0200 |
parents | f89fb9e9abad |
children | 3c11bf4d7778 |
files | backend/doc/schema/postgresql-alter-bed_height.sql |
diffstat | 1 files changed, 22 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- /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;