Mercurial > gemma

comparison schema/gemma.sql @ 4236:27ed6f709195

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Remove unused systemconf.feature_colours from backend * Remove unused routes for `/system/style/{feature}/{attr}`, including the namespace `systemconf` from the schema. This has previously be replaced by a more general mechanism, which is already used by the frontend.
author Bernhard Reiter <bernhard@intevation.de>
date Wed, 21 Aug 2019 16:17:46 +0200
parents 65a5501dc13d
children a7196b55c064 9fef9930aa8a
comparison
equal deleted inserted replaced
4235:966d7eb6d99b 4236:27ed6f709195
386 FOR EACH ROW EXECUTE PROCEDURE update_date_info() 386 FOR EACH ROW EXECUTE PROCEDURE update_date_info()
387 ; 387 ;
388 ALTER TABLE internal.user_profiles ADD 388 ALTER TABLE internal.user_profiles ADD
389 country char(2) NOT NULL REFERENCES users.responsibility_areas; 389 country char(2) NOT NULL REFERENCES users.responsibility_areas;
390 390
391
392 -- Namespace for system wide configuration
393 CREATE SCHEMA systemconf
394 CREATE TABLE feature_colours (
395 feature_name varchar,
396 style_attr varchar,
397 r int NOT NULL CHECK (r >= 0 AND r < 256),
398 g int NOT NULL CHECK (g >= 0 AND g < 256),
399 b int NOT NULL CHECK (b >= 0 AND b < 256),
400 a numeric NOT NULL CHECK (a >= 0 AND a <= 1),
401 PRIMARY KEY (feature_name, style_attr)
402 )
403 ;
404
405 -- Namespace for waterway data that can change in a running system 391 -- Namespace for waterway data that can change in a running system
406 CREATE SCHEMA waterway 392 CREATE SCHEMA waterway
407 393
408 -- Eventually obsolete. 394 -- Eventually obsolete.
409 -- See https://roundup-intern.intevation.de/gemma/issue5 395 -- See https://roundup-intern.intevation.de/gemma/issue5