Mercurial > gemma

diff schema/gemma.sql @ 323:c6b32c6ae95e

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
If sys_admin renames user with pending password request update the pending requests, too.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Thu, 02 Aug 2018 17:22:10 +0200
parents e4bf72cda62e
children b97b3172c61a
line wrap: on
line diff
--- a/schema/gemma.sql	Thu Aug 02 17:17:31 2018 +0200
+++ b/schema/gemma.sql	Thu Aug 02 17:22:10 2018 +0200
@@ -172,7 +172,7 @@
         issued timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
         username varchar NOT NULL
             REFERENCES internal.user_profiles(username)
-                ON DELETE CASCADE
+                ON DELETE CASCADE ON UPDATE CASCADE
     )
 ;