Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
8989:2693bfaf503d | 8990:07dcedddf839 |
---|---|
1 BEGIN; | 1 BEGIN; |
2 | 2 |
3 | 3 |
4 --Add further bed height file header info columns | 4 --Add further bed height file header info columns |
5 | 5 |
6 ALTER TABLE bed_height ADD COLUMN sounding_width_info VARCHAR(32); | 6 ALTER TABLE bed_height ADD COLUMN sounding_width_info VARCHAR(256); |
7 COMMENT ON COLUMN bed_height.sounding_width_info IS 'File header line info "ausgewertete Peilbreite"' ; | 7 COMMENT ON COLUMN bed_height.sounding_width_info IS 'File header line info "ausgewertete Peilbreite"' ; |
8 | 8 |
9 ALTER TABLE bed_height ADD COLUMN "comment" VARCHAR(256); | 9 ALTER TABLE bed_height ADD COLUMN "comment" VARCHAR(256); |
10 COMMENT ON COLUMN bed_height."comment" IS 'File header line info "weitere Bemerkungen"' ; | 10 COMMENT ON COLUMN bed_height."comment" IS 'File header line info "weitere Bemerkungen"' ; |
11 | 11 |