diff options
| author | Brendan Abolivier <contact@brendanabolivier.com> | 2019-04-17 14:57:39 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2019-04-17 14:57:39 +0100 |
| commit | 91934025b93bec62c8f5bf12f1975b0c6bffde93 (patch) | |
| tree | 0bd1029b31353d10868fa3cd3b3b22b70568e472 /synapse/storage/schema | |
| parent | Merge pull request #5071 from matrix-org/babolivier/3pid-check (diff) | |
| parent | Send out emails with links to extend an account's validity period (diff) | |
| download | synapse-91934025b93bec62c8f5bf12f1975b0c6bffde93.tar.xz | |
Merge pull request #5047 from matrix-org/babolivier/account_expiration
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) |