Mercurial > dive4elements > river
annotate backend/doc/schema/postgresql-alter-wsts.sql @ 9003:209b10b144ec
Work on uinfo
| author | gernotbelger |
|---|---|
| date | Thu, 12 Apr 2018 19:17:16 +0200 |
| parents | 3c11bf4d7778 |
| children |
| rev | line source |
|---|---|
| 8967 | 1 BEGIN; |
| 2 | |
| 3 | |
| 4 --Add a column to specify S-INFO selection | |
| 5 ALTER TABLE wsts ADD COLUMN sinfo_selection VARCHAR(1) CHECK((sinfo_selection IS NULL) OR (sinfo_selection IN ('W','Q'))); | |
| 6 COMMENT ON COLUMN wsts.sinfo_selection IS 'Whether and how the WST series is selected within S-INFO calculation types ("W"=without-Q-group, "Q"=with-Q-group, NULL=not-selectable)' ; | |
| 7 | |
| 8 | |
| 9 COMMIT; |