summary refs log tree commit diff
path: root/synapse/storage/schema/delta
diff options
context:
space:
mode:
authorBrendan Abolivier <babolivier@matrix.org>2019-04-10 17:58:47 +0100
committerBrendan Abolivier <babolivier@matrix.org>2019-04-17 14:42:20 +0100
commit20f0617e87924c929f0db0c06d30de0c8d15081c (patch)
tree813206ef9ad64726925d976d74dbcf6afa8167c3 /synapse/storage/schema/delta
parentAdd account expiration feature (diff)
downloadsynapse-20f0617e87924c929f0db0c06d30de0c8d15081c.tar.xz
Send out emails with links to extend an account's validity period
Diffstat (limited to 'synapse/storage/schema/delta')
-rw-r--r--synapse/storage/schema/delta/54/account_validity.sql9
1 files changed, 8 insertions, 1 deletions
diff --git a/synapse/storage/schema/delta/54/account_validity.sql b/synapse/storage/schema/delta/54/account_validity.sql
index 57249262d7..2357626000 100644
--- a/synapse/storage/schema/delta/54/account_validity.sql
+++ b/synapse/storage/schema/delta/54/account_validity.sql
@@ -13,8 +13,15 @@
  * limitations under the License.
  */
 
+DROP TABLE IF EXISTS account_validity;
+
 -- Track what users are in public rooms.
 CREATE TABLE IF NOT EXISTS account_validity (
     user_id TEXT PRIMARY KEY,
-    expiration_ts_ms BIGINT NOT NULL
+    expiration_ts_ms BIGINT NOT NULL,
+    email_sent BOOLEAN NOT NULL,
+    renewal_token TEXT
 );
+
+CREATE INDEX account_validity_email_sent_idx ON account_validity(email_sent, expiration_ts_ms)
+CREATE UNIQUE INDEX account_validity_renewal_string_idx ON account_validity(renewal_token)