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;