Mercurial > gemma
diff schema/updates/1451/01.stats_updates.sql @ 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 | |
children | 7f5fc8ece589 |
line wrap: on
line diff
--- /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;