Mercurial > dive4elements > river

annotate backend/doc/schema/postgresql-alter-bed_height.sql @ 8978:b5600453bb8f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
SINFO Calculations: do not produce result rows if some input data has missing values. Also check for years of waterlevels in flow depth development calculation.
author gernotbelger
date Thu, 05 Apr 2018 11:57:54 +0200
parents 5b23efe99e80
children 07dcedddf839
rev   line source
8966
5b23efe99e80 Add two bed_height meta info columns and bed_height_values min/max_height
mschaefer
parents:
diff changeset
1 BEGIN;
5b23efe99e80 Add two bed_height meta info columns and bed_height_values min/max_height
mschaefer
parents:
diff changeset
2
5b23efe99e80 Add two bed_height meta info columns and bed_height_values min/max_height
mschaefer
parents:
diff changeset
3
5b23efe99e80 Add two bed_height meta info columns and bed_height_values min/max_height
mschaefer
parents:
diff changeset
4 --Add further bed height file header info columns
5b23efe99e80 Add two bed_height meta info columns and bed_height_values min/max_height
mschaefer
parents:
diff changeset
5
5b23efe99e80 Add two bed_height meta info columns and bed_height_values min/max_height
mschaefer
parents:
diff changeset
6 ALTER TABLE bed_height ADD COLUMN sounding_width_info VARCHAR(32);
5b23efe99e80 Add two bed_height meta info columns and bed_height_values min/max_height
mschaefer
parents:
diff changeset
7 COMMENT ON COLUMN bed_height.sounding_width_info IS 'File header line info "ausgewertete Peilbreite"' ;
5b23efe99e80 Add two bed_height meta info columns and bed_height_values min/max_height
mschaefer
parents:
diff changeset
8
5b23efe99e80 Add two bed_height meta info columns and bed_height_values min/max_height
mschaefer
parents:
diff changeset
9 ALTER TABLE bed_height ADD COLUMN "comment" VARCHAR(256);
5b23efe99e80 Add two bed_height meta info columns and bed_height_values min/max_height
mschaefer
parents:
diff changeset
10 COMMENT ON COLUMN bed_height."comment" IS 'File header line info "weitere Bemerkungen"' ;
5b23efe99e80 Add two bed_height meta info columns and bed_height_values min/max_height
mschaefer
parents:
diff changeset
11
5b23efe99e80 Add two bed_height meta info columns and bed_height_values min/max_height
mschaefer
parents:
diff changeset
12
5b23efe99e80 Add two bed_height meta info columns and bed_height_values min/max_height
mschaefer
parents:
diff changeset
13 --Add bed_height_values columns for min height (Talweg) and max height (Kammlage) (same type as existing value column)
5b23efe99e80 Add two bed_height meta info columns and bed_height_values min/max_height
mschaefer
parents:
diff changeset
14
5b23efe99e80 Add two bed_height meta info columns and bed_height_values min/max_height
mschaefer
parents:
diff changeset
15 ALTER TABLE bed_height_values ADD COLUMN min_height NUMERIC;
5b23efe99e80 Add two bed_height meta info columns and bed_height_values min/max_height
mschaefer
parents:
diff changeset
16 COMMENT ON COLUMN bed_height_values.min_height IS 'Minimum bed height (Talweg) in m' ;
5b23efe99e80 Add two bed_height meta info columns and bed_height_values min/max_height
mschaefer
parents:
diff changeset
17
5b23efe99e80 Add two bed_height meta info columns and bed_height_values min/max_height
mschaefer
parents:
diff changeset
18 ALTER TABLE bed_height_values ADD COLUMN max_height NUMERIC;
5b23efe99e80 Add two bed_height meta info columns and bed_height_values min/max_height
mschaefer
parents:
diff changeset
19 COMMENT ON COLUMN bed_height_values.max_height IS 'Maximum bed height (Kammlage) in m' ;
5b23efe99e80 Add two bed_height meta info columns and bed_height_values min/max_height
mschaefer
parents:
diff changeset
20
5b23efe99e80 Add two bed_height meta info columns and bed_height_values min/max_height
mschaefer
parents:
diff changeset
21
5b23efe99e80 Add two bed_height meta info columns and bed_height_values min/max_height
mschaefer
parents:
diff changeset
22 COMMIT;
http://dive4elements.wald.intevation.org