summary refs log tree commit diff
path: root/synapse/storage/schema/delta
diff options
context:
space:
mode:
authorMark Haines <mark.haines@matrix.org>2016-05-05 13:42:44 +0100
committerMark Haines <mark.haines@matrix.org>2016-05-05 13:42:44 +0100
commit9c272da05fcf51534aaa877647bc3b82bf841cf3 (patch)
treeb4ad76ff6acd5d5e38907208065689fb37c42e4c /synapse/storage/schema/delta
parentMerge pull request #762 from matrix-org/erikj/report_event (diff)
downloadsynapse-9c272da05fcf51534aaa877647bc3b82bf841cf3.tar.xz
Add an openidish mechanism for proving to third parties that you own a given user_id
Diffstat (limited to 'synapse/storage/schema/delta')
-rw-r--r--synapse/storage/schema/delta/32/openid.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/synapse/storage/schema/delta/32/openid.sql b/synapse/storage/schema/delta/32/openid.sql
new file mode 100644
index 0000000000..36f37b11c8
--- /dev/null
+++ b/synapse/storage/schema/delta/32/openid.sql
@@ -0,0 +1,9 @@
+
+CREATE TABLE open_id_tokens (
+    token TEXT NOT NULL PRIMARY KEY,
+    ts_valid_until_ms bigint NOT NULL,
+    user_id TEXT NOT NULL,
+    UNIQUE (token)
+);
+
+CREATE index open_id_tokens_ts_valid_until_ms ON open_id_tokens(ts_valid_until_ms);