https://bugs.freedesktop.org/show_bug.cgi?id=71162
--- Comment #4 from Björn Michaelsen <[email protected]> --- Created attachment 89135 --> https://bugs.freedesktop.org/attachment.cgi?id=89135&action=edit load_merge.sql Thanks David. Dumping the current script here as 'our' backup copy. Here is the blurb that comes with it: "Sometimes users wind up with two accounts on a Gerrit server, this is especially common with OpenID installations when the user forgets which OpenID provider he had used, and opens yet another account with a different OpenID identity... but the site administrator knows they are the same person. Unfortunately this has happened often enough on review.source.android.com that I've developed a set of PostgreSQL scripts to handle merging the accounts. The first script, load_merge.sql, creates a temporary table called "links" which contains a mapping of source account_id to destination account_id. This mapping tries to map the most recently created account for a user to the oldest account for the same user, by comparing email addresses and registration dates. Administrators can (and probably should) edit this temporary table before running the second script. The second script, merge_accounts.sql, performs the merge by updating all records in the database in a transaction, but does not commit it at the end. This allows the administrator to double check any records by query before committing the merge result for good." -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
