From 61cd5d9045b767e2c1ef4e48e67ed0c70e1092fe Mon Sep 17 00:00:00 2001 From: David Baker Date: Wed, 29 Apr 2015 16:57:14 +0100 Subject: Be more postgressive --- synapse/storage/schema/delta/17/user_threepids.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'synapse/storage/schema/delta') diff --git a/synapse/storage/schema/delta/17/user_threepids.sql b/synapse/storage/schema/delta/17/user_threepids.sql index bbb472ee8a..f3d1efe4e0 100644 --- a/synapse/storage/schema/delta/17/user_threepids.sql +++ b/synapse/storage/schema/delta/17/user_threepids.sql @@ -1,9 +1,9 @@ CREATE TABLE user_threepids ( - user TEXT NOT NULL, + user_id TEXT NOT NULL, medium TEXT NOT NULL, address TEXT NOT NULL, validated_at BIGINT NOT NULL, added_at BIGINT NOT NULL, CONSTRAINT user_medium_address UNIQUE (user, medium, address) ); -CREATE INDEX user_threepids_user ON user_threepids(user); +CREATE INDEX user_threepids_user_id ON user_threepids(user_id); -- cgit 1.4.1