Be postgressive

1 files changed, 3 insertions, 4 deletions

diff --git a/synapse/storage/schema/delta/17/user_threepids.sql b/synapse/storage/schema/delta/17/user_threepids.sql
index fa16589019..bbb472ee8a 100644
--- a/synapse/storage/schema/delta/17/user_threepids.sql
+++ b/synapse/storage/schema/delta/17/user_threepids.sql
@@ -1,10 +1,9 @@
 CREATE TABLE user_threepids (
-    id INTEGER PRIMARY KEY NOT NULL,
     user TEXT NOT NULL,
     medium TEXT NOT NULL,
     address TEXT NOT NULL,
-    validated_at INTEGER NOT NULL,
-    added_at INTEGER NOT NULL,
-    CONSTRAINT user_medium_address UNIQUE (user, medium, address) ON CONFLICT REPLACE
+    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);