Mercurial > dive4elements > river

annotate backend/doc/schema/postgresql-alter-bed_height.sql @ 8969:fe81eb39080c

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Avoid guessing year 1950 for HQ50 etc.
author mschaefer
date Tue, 03 Apr 2018 09:54:26 +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