Mercurial > gemma

changeset 1822:f1351a58da35

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
SQL: typo fix.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 16 Jan 2019 11:31:36 +0100
parents 332e42a2088d
children 7d37d9f5f272
files schema/gemma.sql
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- 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,