diff options
| author | Erik Johnston <erik@matrix.org> | 2017-09-28 12:23:15 +0100 |
|---|---|---|
| committer | Erik Johnston <erik@matrix.org> | 2017-09-28 12:23:15 +0100 |
| commit | 77f1d24de3c696f52bc1ba6d0f61e82f03a9de7a (patch) | |
| tree | 0e149f5440080386652c343d2c9cce6dd67ac625 /synapse/storage/schema/delta | |
| parent | Delete expired url cache data (diff) | |
| download | synapse-77f1d24de3c696f52bc1ba6d0f61e82f03a9de7a.tar.xz | |
More brackets
Diffstat (limited to 'synapse/storage/schema/delta')
| -rw-r--r-- | synapse/storage/schema/delta/44/expire_url_cache.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/synapse/storage/schema/delta/44/expire_url_cache.sql b/synapse/storage/schema/delta/44/expire_url_cache.sql index 96202bd2a6..997e790b6d 100644 --- a/synapse/storage/schema/delta/44/expire_url_cache.sql +++ b/synapse/storage/schema/delta/44/expire_url_cache.sql @@ -14,4 +14,4 @@ */ CREATE INDEX local_media_repository_url_idx ON local_media_repository(created_ts) WHERE url_cache IS NOT NULL; -CREATE INDEX local_media_repository_url_cache_expires_idx ON local_media_repository_url_cache(download_ts + expires); +CREATE INDEX local_media_repository_url_cache_expires_idx ON local_media_repository_url_cache((download_ts + expires)); |