summary refs log tree commit diff
path: root/jenkins-postgres.sh
diff options
context:
space:
mode:
authorErik Johnston <erik@matrix.org>2016-10-27 14:14:44 +0100
committerErik Johnston <erik@matrix.org>2016-10-27 14:14:44 +0100
commit1fc1bc2a51b025e46e3d44056ea1836dfc48cc6e (patch)
treecfe3173336cbc2d0e2440119bdc9e0eb4bbf5594 /jenkins-postgres.sh
parentUpdate changelog (diff)
downloadsynapse-1fc1bc2a51b025e46e3d44056ea1836dfc48cc6e.tar.xz
Fix user_threepids schema delta
The delta `37/user_threepids.sql` aimed to update all the email
addresses to be lower case, however duplicate emails may exist in the
table already.

This commit adds a step where the delta moves the duplicate emails to a
new `medium` `email_old`. Only the most recently used account keeps the
binding intact. We move rather than delete so that we retain some record
of which emails were associated with which account.
Diffstat (limited to 'jenkins-postgres.sh')
0 files changed, 0 insertions, 0 deletions