Mercurial > gemma

diff schema/gemma.sql @ 5129:882b3d2308c4 queued-stage-done

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Merge default into queued-stage-done
author Tom Gottfried <tom@intevation.de>
date Fri, 27 Mar 2020 12:24:25 +0100
parents 0b6b62d247e8 e21cbb9768a2
children 722b7c305319
line wrap: on
line diff
--- a/schema/gemma.sql	Fri Mar 27 00:40:52 2020 +0100
+++ b/schema/gemma.sql	Fri Mar 27 12:24:25 2020 +0100
@@ -721,6 +721,9 @@
     CREATE TRIGGER fairway_dimensions_date_info
         BEFORE UPDATE ON fairway_dimensions
         FOR EACH ROW EXECUTE PROCEDURE update_date_info()
+    CREATE CONSTRAINT TRIGGER fairway_dimensions_area_unique
+        AFTER INSERT OR UPDATE OF area, staging_done ON fairway_dimensions
+        FOR EACH ROW EXECUTE FUNCTION prevent_st_equals('area', 'staging_done')
 
     --
     -- Bottlenecks