Mercurial > gemma

comparison schema/gemma.sql @ 4919:399458e60a9b fairway-marks-import

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Geo styles as ZIP: Forgot to change the schema itself.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Fri, 14 Feb 2020 07:41:43 +0100
parents 8c1a3d5e3962
children 9bd6a0ca63ea
comparison
equal deleted inserted replaced
4918:4a9a1e323e11 4919:399458e60a9b
404 view_def text CHECK (is_valid_from_item(view_def)), 404 view_def text CHECK (is_valid_from_item(view_def)),
405 -- Column in output of SQL statement to be used as primary key: 405 -- Column in output of SQL statement to be used as primary key:
406 key_column varchar, 406 key_column varchar,
407 -- SRID to be used with SQL view: 407 -- SRID to be used with SQL view:
408 srid int REFERENCES spatial_ref_sys, 408 srid int REFERENCES spatial_ref_sys,
409 -- SLD style document: 409 -- SLD style document or ZIP blob:
410 style xml CHECK(style IS DOCUMENT), 410 style bytea,
411 as_wms boolean NOT NULL DEFAULT TRUE, 411 as_wms boolean NOT NULL DEFAULT TRUE,
412 as_wfs boolean NOT NULL DEFAULT TRUE, 412 as_wfs boolean NOT NULL DEFAULT TRUE,
413 -- Either give a valid relation or a SQL statement: 413 -- Either give a valid relation or a SQL statement:
414 CHECK (to_regclass(schema || '.' || name) IS NOT NULL 414 CHECK (to_regclass(schema || '.' || name) IS NOT NULL
415 OR view_def IS NOT NULL) 415 OR view_def IS NOT NULL)