Mercurial > gemma

diff 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
line wrap: on
line diff
--- 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
+    )
 ;