Mercurial > gemma

changeset 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 34ecfd8dc11e
children 8bacd556ea39
files schema/gemma.sql
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
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
     )
 ;