Mercurial > dive4elements > river
comparison backend/doc/schema/postgresql-alter-bed_height.sql @ 8966:5b23efe99e80
Add two bed_height meta info columns and bed_height_values min/max_height
| author | mschaefer |
|---|---|
| date | Tue, 03 Apr 2018 08:29:16 +0200 |
| parents | |
| children | 07dcedddf839 |
comparison
equal
deleted
inserted
replaced
| 8965:f89fb9e9abad | 8966:5b23efe99e80 |
|---|---|
| 1 BEGIN; | |
| 2 | |
| 3 | |
| 4 --Add further bed height file header info columns | |
| 5 | |
| 6 ALTER TABLE bed_height ADD COLUMN sounding_width_info VARCHAR(32); | |
| 7 COMMENT ON COLUMN bed_height.sounding_width_info IS 'File header line info "ausgewertete Peilbreite"' ; | |
| 8 | |
| 9 ALTER TABLE bed_height ADD COLUMN "comment" VARCHAR(256); | |
| 10 COMMENT ON COLUMN bed_height."comment" IS 'File header line info "weitere Bemerkungen"' ; | |
| 11 | |
| 12 | |
| 13 --Add bed_height_values columns for min height (Talweg) and max height (Kammlage) (same type as existing value column) | |
| 14 | |
| 15 ALTER TABLE bed_height_values ADD COLUMN min_height NUMERIC; | |
| 16 COMMENT ON COLUMN bed_height_values.min_height IS 'Minimum bed height (Talweg) in m' ; | |
| 17 | |
| 18 ALTER TABLE bed_height_values ADD COLUMN max_height NUMERIC; | |
| 19 COMMENT ON COLUMN bed_height_values.max_height IS 'Maximum bed height (Kammlage) in m' ; | |
| 20 | |
| 21 | |
| 22 COMMIT; |