Mercurial > lada > lada-server
diff db_schema/lada_schema.sql @ 1129:48c0132dbc85
Adapt definition to LAF and validate uniqueness of idAlt.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Tue, 01 Nov 2016 12:47:25 +0100 |
parents | 70b51893f15b |
children | 84ff77bba9b0 |
line wrap: on
line diff
--- a/db_schema/lada_schema.sql Tue Nov 01 12:11:06 2016 +0100 +++ b/db_schema/lada_schema.sql Tue Nov 01 12:47:25 2016 +0100 @@ -192,7 +192,7 @@ CREATE TABLE probe ( id serial PRIMARY KEY, - id_alt character varying(20) UNIQUE NOT NULL + id_alt character varying(16) UNIQUE NOT NULL DEFAULT 'sss' || lpad(nextval('land.probe_probe_id_seq')::varchar, 12, '0') || 'Y',