Mercurial > gemma
changeset 5384:18969a4d31b6 extented-report
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 | d61aab631d65 |
children | 7f5fc8ece589 |
files | schema/auth.sql schema/gemma.sql schema/updates/1451/01.stats_updates.sql schema/version.sql |
diffstat | 4 files changed, 14 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/schema/auth.sql Wed Jun 30 11:37:07 2021 +0200 +++ b/schema/auth.sql Thu Jul 01 21:56:50 2021 +0200 @@ -62,6 +62,7 @@ GRANT UPDATE ON sys_admin.published_services TO sys_admin; GRANT INSERT, DELETE, UPDATE ON sys_admin.password_reset_requests TO sys_admin; GRANT DELETE ON import.imports, import.import_logs TO sys_admin; +GRANT INSERT, DELETE, UPDATE ON sys_admin.stats_updates TO sys_admin; -- -- Privileges assigned directly to metamorph
--- a/schema/gemma.sql Wed Jun 30 11:37:07 2021 +0200 +++ b/schema/gemma.sql Thu Jul 01 21:56:50 2021 +0200 @@ -446,6 +446,12 @@ UNIQUE (group_name, schema, name, ord), FOREIGN KEY(schema, name) REFERENCES published_services ) + + -- Table to store scripts which updates aggregated data. + CREATE TABLE stats_updates ( + name varchar PRIMARY key, + script TEXT NULL + ) ;
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/schema/updates/1451/01.stats_updates.sql Thu Jul 01 21:56:50 2021 +0200 @@ -0,0 +1,6 @@ +CREATE TABLE sys_admin.stats_updates ( + name varchar PRIMARY key, + script TEXT NULL +); + +GRANT INSERT, DELETE, UPDATE ON sys_admin.stats_updates TO sys_admin;