# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1547634696 -3600
# Node ID f1351a58da351173d5341c36cf4b9e2f01879104
# Parent  332e42a2088db6309f82a44db353b4dfc6f37c46
SQL: typo fix.

diff -r 332e42a2088d -r f1351a58da35 schema/gemma.sql
--- a/schema/gemma.sql	Wed Jan 16 11:28:33 2019 +0100
+++ b/schema/gemma.sql	Wed Jan 16 11:31:36 2019 +0100
@@ -237,7 +237,7 @@
 
     CREATE TABLE gauges (
         id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
-        location isrs UNIQUE NOT NULL KEY CHECK(
+        location isrs UNIQUE NOT NULL CHECK(
             (location).orc SIMILAR TO 'G[[:digit:]]{4}'
             AND CAST(substring((location).orc from 2 for 4) AS int) < 2048),
         objname varchar NOT NULL,