summary refs log tree commit diff
path: root/synapse/storage
diff options
context:
space:
mode:
authorDavid Baker <dave@matrix.org>2015-04-29 16:49:44 +0100
committerDavid Baker <dave@matrix.org>2015-04-29 16:50:16 +0100
commit4669def000fbf16da94055c4f9cbc0d705259ba2 (patch)
tree85236a8ec9c8712c17f6e2759def1b0adec90315 /synapse/storage
parenttxn.execute doesn't return cursors (diff)
downloadsynapse-4669def000fbf16da94055c4f9cbc0d705259ba2.tar.xz
Oops, forgot the schema delta file
Diffstat (limited to 'synapse/storage')
-rw-r--r--synapse/storage/schema/delta/17/user_threepids.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/synapse/storage/schema/delta/17/user_threepids.sql b/synapse/storage/schema/delta/17/user_threepids.sql
new file mode 100644
index 0000000000..fa16589019
--- /dev/null
+++ b/synapse/storage/schema/delta/17/user_threepids.sql
@@ -0,0 +1,10 @@
+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
+);
+CREATE INDEX user_threepids_user ON user_threepids(user);