Mercurial > gemma

comparison schema/gemma.sql @ 5384:18969a4d31b6 extented-report

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added a table to store SQL update scripts for aggregated data.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Thu, 01 Jul 2021 21:56:50 +0200
parents ac1986c23889
children fe3f651bb03d
comparison
equal deleted inserted replaced
5383:d61aab631d65 5384:18969a4d31b6
444 ord int NOT NULL DEFAULT 0, 444 ord int NOT NULL DEFAULT 0,
445 PRIMARY KEY (group_name, schema, name), 445 PRIMARY KEY (group_name, schema, name),
446 UNIQUE (group_name, schema, name, ord), 446 UNIQUE (group_name, schema, name, ord),
447 FOREIGN KEY(schema, name) REFERENCES published_services 447 FOREIGN KEY(schema, name) REFERENCES published_services
448 ) 448 )
449
450 -- Table to store scripts which updates aggregated data.
451 CREATE TABLE stats_updates (
452 name varchar PRIMARY key,
453 script TEXT NULL
454 )
449 ; 455 ;
450 456
451 457
452 -- Namespace for user management related data 458 -- Namespace for user management related data
453 CREATE SCHEMA users 459 CREATE SCHEMA users