aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorPaul Sokolovsky <paul.sokolovsky@linaro.org>2015-08-21 13:50:38 +0300
committerPaul Sokolovsky <paul.sokolovsky@linaro.org>2015-08-21 13:50:38 +0300
commitfc81f9403da5a6df1d869c6118ade1fea07a0141 (patch)
treec6e105badf58dcbf69648159643bd178ee8705f6
parent0005559b7972bf9425bc410e746985a8abc18535 (diff)
downloadlinaro-git-tools-fc81f9403da5a6df1d869c6118ade1fea07a0141.tar.gz
gerrit/useful_queries.sql: Set dup name to UNUSED-<fullname>.
Some duplicate accounts may be used as reviewers already, so will be shown as "UNUSED" which is quite confusing. Allow to identify a person in such case. Change-Id: Ibbd0b8fcc02ffc905e1fb59851a6735df38cff11
-rw-r--r--gerrit/useful_queries.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/gerrit/useful_queries.sql b/gerrit/useful_queries.sql
index d037453..afe9e79 100644
--- a/gerrit/useful_queries.sql
+++ b/gerrit/useful_queries.sql
@@ -2,5 +2,5 @@
SELECT full_name, preferred_email, COUNT(*) FROM accounts GROUP BY full_name, preferred_email HAVING COUNT(*) > 1;
-- Deactivate duplicate account
-UPDATE accounts SET inactive='Y', full_name='UNUSED', preferred_email='UNUSED' WHERE account_id=?;
+UPDATE accounts SET inactive='Y', full_name='UNUSED-'||full_name, preferred_email='UNUSED' WHERE account_id=?;
DELETE FROM account_external_ids WHERE account_id=?;