summary refs log tree commit diff
path: root/synapse/storage/schema/delta
diff options
context:
space:
mode:
authorDavid Baker <dave@matrix.org>2015-04-29 16:53:41 +0100
committerDavid Baker <dave@matrix.org>2015-04-29 16:53:41 +0100
commitfb95035a6534d5a16776242b5f31ceef567ca2cc (patch)
tree4cea7fafac55762f84b2474646e9a8cf0f0c03b5 /synapse/storage/schema/delta
parentOops, forgot the schema delta file (diff)
downloadsynapse-fb95035a6534d5a16776242b5f31ceef567ca2cc.tar.xz
Be postgressive
Diffstat (limited to 'synapse/storage/schema/delta')
-rw-r--r--synapse/storage/schema/delta/17/user_threepids.sql7
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);