summary refs log tree commit diff
path: root/synapse
diff options
context:
space:
mode:
authorDavid Baker <dave@matrix.org>2015-04-29 16:58:42 +0100
committerDavid Baker <dave@matrix.org>2015-04-29 16:58:42 +0100
commitf8c30faf256bb47c6725b7752e36e49c519d1adc (patch)
tree85ca48d52fed613fd77827ea0ccef1ab04a99fc0 /synapse
parentBe more postgressive (diff)
downloadsynapse-f8c30faf256bb47c6725b7752e36e49c519d1adc.tar.xz
Oops, update the contraint too
Diffstat (limited to 'synapse')
-rw-r--r--synapse/storage/schema/delta/17/user_threepids.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/synapse/storage/schema/delta/17/user_threepids.sql b/synapse/storage/schema/delta/17/user_threepids.sql
index f3d1efe4e0..c17715ac80 100644
--- a/synapse/storage/schema/delta/17/user_threepids.sql
+++ b/synapse/storage/schema/delta/17/user_threepids.sql
@@ -4,6 +4,6 @@ CREATE TABLE user_threepids (
     address TEXT NOT NULL,
     validated_at BIGINT NOT NULL,
     added_at BIGINT NOT NULL,
-    CONSTRAINT user_medium_address UNIQUE (user, medium, address)
+    CONSTRAINT user_medium_address UNIQUE (user_id, medium, address)
 );
 CREATE INDEX user_threepids_user_id ON user_threepids(user_id);