Mercurial > gemma
view schema/updates/1409/01.add_fm_validity_indexes.sql @ 5472:9321d9fb719f
improve README.md about licensing
* Use meanwhile established `SPDX-FileCopyrightText:` line to give the
holder of the usage rights, improve the explanation.
* Use `SPDX-License-Identifier:` also here.
author | Bernhard Reiter <bernhard@intevation.de> |
---|---|
date | Tue, 20 Jul 2021 11:50:17 +0200 |
parents | de190de05f67 |
children |
line wrap: on
line source
DO LANGUAGE plpgsql $$ DECLARE table_suffix varchar; BEGIN FOREACH table_suffix IN ARRAY ARRAY[ 'bcnlat_hydro', 'bcnlat_ienc', 'boycar', 'boylat_hydro', 'boylat_ienc', 'boysaw', 'boyspp', 'daymar_hydro', 'daymar_ienc', 'lights', 'rtpbcn', 'topmar', 'notmrk'] LOOP EXECUTE format( 'CREATE INDEX fairway_marks_%1$s_validity ' 'ON waterway.fairway_marks_%1$s USING GiST (validity)', table_suffix); END LOOP; END; $$;