Mercurial > gemma
comparison schema/gemma.sql @ 4930:8b83b18a1d49 fairway-marks-import
Added database models for group layers.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Fri, 14 Feb 2020 17:31:17 +0100 |
parents | b86ce7fc4da3 |
children | b3b2ba09a450 |
comparison
equal
deleted
inserted
replaced
4929:9b9b4150f296 | 4930:8b83b18a1d49 |
---|---|
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) |
416 ) | 416 ) |
417 | |
418 CREATE TABLE layer_groups ( | |
419 name varchar PRIMARY KEY | |
420 ) | |
421 | |
422 CREATE TABLE grouped_layers ( | |
423 group_name varchar REFERENCES layer_groups ON DELETE CASCADE, | |
424 schema varchar, | |
425 name varchar, | |
426 ord int NOT NULL DEFAULT 0, | |
427 PRIMARY KEY (group_name, schema, name), | |
428 UNIQUE (group_name, schema, name, ord), | |
429 FOREIGN KEY(schema, name) REFERENCES published_services | |
430 ) | |
417 ; | 431 ; |
418 | 432 |
419 | 433 |
420 -- Namespace for user management related data | 434 -- Namespace for user management related data |
421 CREATE SCHEMA users | 435 CREATE SCHEMA users |