Mercurial > dive4elements > river

annotate backend/doc/schema/postgresql-alter-bed_height.sql @ 9003:209b10b144ec

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Work on uinfo
author gernotbelger
date Thu, 12 Apr 2018 19:17:16 +0200
parents 07dcedddf839
children
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
8990
07dcedddf839 Oracle schema extension added, a few changes in the postgresql schema
mschaefer
parents: 8966
diff changeset
6 ALTER TABLE bed_height ADD COLUMN sounding_width_info VARCHAR(256);
8966
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