diff options
| author | David Baker <dave@matrix.org> | 2015-04-29 16:53:41 +0100 |
|---|---|---|
| committer | David Baker <dave@matrix.org> | 2015-04-29 16:53:41 +0100 |
| commit | fb95035a6534d5a16776242b5f31ceef567ca2cc (patch) | |
| tree | 4cea7fafac55762f84b2474646e9a8cf0f0c03b5 /synapse/storage/schema/delta/17 | |
| parent | Oops, forgot the schema delta file (diff) | |
| download | synapse-fb95035a6534d5a16776242b5f31ceef567ca2cc.tar.xz | |
Be postgressive
Diffstat (limited to 'synapse/storage/schema/delta/17')
| -rw-r--r-- | synapse/storage/schema/delta/17/user_threepids.sql | 7 |
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); |