Mercurial > dive4elements > river
view backend/doc/schema/postgresql-alter-bed_height.sql @ 8973:35afa0349782
New field wsts.sinfo_selection
author | mschaefer |
---|---|
date | Tue, 03 Apr 2018 10:29:57 +0200 |
parents | 5b23efe99e80 |
children | 07dcedddf839 |
line wrap: on
line source
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;