view backend/doc/schema/postgresql-alter-wsts.sql @ 9004:4635872e7117

DB-Port
author gernotbelger
date Tue, 17 Apr 2018 13:18:56 +0200
parents 3c11bf4d7778
children
line wrap: on
line source
BEGIN;


--Add a column to specify S-INFO selection
ALTER TABLE wsts ADD COLUMN sinfo_selection VARCHAR(1) CHECK((sinfo_selection IS NULL) OR (sinfo_selection IN ('W','Q')));
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)' ;


COMMIT;

http://dive4elements.wald.intevation.org