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 |