annotate backend/doc/schema/postgresql-alter-bed_height.sql @ 8990:07dcedddf839

Oracle schema extension added, a few changes in the postgresql schema
author mschaefer
date Tue, 10 Apr 2018 16:40:52 +0200
parents 5b23efe99e80
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