Mercurial > gemma
view schema/updates/1102/01.bn_constraint.sql @ 4369:7c91cb922352
client: fix systemconfiguration classbreak layout
* Use more width for a single classbreak so that in case of negative
numbers with two digits after the decimal point (e.g. `-0.05`),
we can still see the right most digit.
author | Bernhard Reiter <bernhard@intevation.de> |
---|---|
date | Wed, 11 Sep 2019 10:00:52 +0200 |
parents | 24c5eec22c2d |
children |
line wrap: on
line source
ALTER TABLE waterway.bottlenecks DROP CONSTRAINT IF EXISTS bottlenecks_bottleneck_id_validity_key, DROP CONSTRAINT IF EXISTS bottlenecks_bottleneck_id_validity_excl, DROP CONSTRAINT IF EXISTS bottlenecks_bottleneck_id_validity_staging_done_key, DROP CONSTRAINT IF EXISTS bottlenecks_bottleneck_id_validity_staging_done_excl; ALTER TABLE waterway.bottlenecks ADD CONSTRAINT bottlenecks_bottleneck_id_validity_staging_done_key UNIQUE (bottleneck_id, validity, staging_done), ADD CONSTRAINT bottlenecks_bottleneck_id_validity_staging_done_excl EXCLUDE USING GiST (bottleneck_id WITH =, validity WITH &&, CAST(staging_done AS int) WITH =) DEFERRABLE INITIALLY DEFERRED;