Mercurial > gemma
changeset 1824:4d23461bea4d
Backed out changeset f1351a58da35 (no staging needed)
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Wed, 16 Jan 2019 12:42:19 +0100 |
parents | 7d37d9f5f272 |
children | 484ae4fe09d7 |
files | schema/gemma.sql |
diffstat | 1 files changed, 1 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/schema/gemma.sql Wed Jan 16 12:12:44 2019 +0100 +++ b/schema/gemma.sql Wed Jan 16 12:42:19 2019 +0100 @@ -237,7 +237,7 @@ CREATE TABLE gauges ( id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, - location isrs UNIQUE NOT NULL CHECK( + location isrs UNIQUE NOT NULL KEY CHECK( (location).orc SIMILAR TO 'G[[:digit:]]{4}' AND CAST(substring((location).orc from 2 for 4) AS int) < 2048), objname varchar NOT NULL,