Mercurial > gemma

diff schema/gemma.sql @ 1194:7db850de0952

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added a signer who makes the final decison on an import. Generate a log entry when the final decison is made.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Sun, 18 Nov 2018 18:29:25 +0100
parents 58acc343b1b6
children 9f7dc950ffd2
line wrap: on
line diff
--- a/schema/gemma.sql	Fri Nov 16 18:35:09 2018 +0100
+++ b/schema/gemma.sql	Sun Nov 18 18:29:25 2018 +0100
@@ -527,7 +527,12 @@
     kind  varchar NOT NULL,
     username varchar NOT NULL
         REFERENCES internal.user_profiles(username)
-            ON DELETE CASCADE ON UPDATE CASCADE,
+            ON DELETE CASCADE
+            ON UPDATE CASCADE,
+    signer varchar
+        REFERENCES internal.user_profiles(username)
+            ON DELETE SET NULL
+            ON UPDATE CASCADE,
     data TEXT
 );
 
@@ -574,6 +579,4 @@
 CREATE TRIGGER delete_import AFTER DELETE ON waterway.track_imports
    FOR EACH ROW EXECUTE PROCEDURE waterway.del_import();
 
-
-
 COMMIT;