diff options
| author | Brendan Abolivier <babolivier@matrix.org> | 2019-04-10 17:58:47 +0100 |
|---|---|---|
| committer | Brendan Abolivier <babolivier@matrix.org> | 2019-04-17 14:42:20 +0100 |
| commit | 20f0617e87924c929f0db0c06d30de0c8d15081c (patch) | |
| tree | 813206ef9ad64726925d976d74dbcf6afa8167c3 /synapse/storage/schema | |
| parent | Add account expiration feature (diff) | |
| download | synapse-20f0617e87924c929f0db0c06d30de0c8d15081c.tar.xz | |
Send out emails with links to extend an account's validity period
Diffstat (limited to 'synapse/storage/schema')
| -rw-r--r-- | synapse/storage/schema/delta/54/account_validity.sql | 9 |
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) |