annotate backend/doc/schema/postgresql-alter-wsts.sql @ 8985:27851cfda84a

Work on SINFO Exporters
author gernotbelger
date Fri, 06 Apr 2018 14:13:14 +0200
parents 3c11bf4d7778
children
rev   line source
8967
3c11bf4d7778 Add wsts column for S-INFO selection flag
mschaefer
parents:
diff changeset
1 BEGIN;
3c11bf4d7778 Add wsts column for S-INFO selection flag
mschaefer
parents:
diff changeset
2
3c11bf4d7778 Add wsts column for S-INFO selection flag
mschaefer
parents:
diff changeset
3
3c11bf4d7778 Add wsts column for S-INFO selection flag
mschaefer
parents:
diff changeset
4 --Add a column to specify S-INFO selection
3c11bf4d7778 Add wsts column for S-INFO selection flag
mschaefer
parents:
diff changeset
5 ALTER TABLE wsts ADD COLUMN sinfo_selection VARCHAR(1) CHECK((sinfo_selection IS NULL) OR (sinfo_selection IN ('W','Q')));
3c11bf4d7778 Add wsts column for S-INFO selection flag
mschaefer
parents:
diff changeset
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)' ;
3c11bf4d7778 Add wsts column for S-INFO selection flag
mschaefer
parents:
diff changeset
7
3c11bf4d7778 Add wsts column for S-INFO selection flag
mschaefer
parents:
diff changeset
8
3c11bf4d7778 Add wsts column for S-INFO selection flag
mschaefer
parents:
diff changeset
9 COMMIT;

http://dive4elements.wald.intevation.org