summary refs log tree commit diff
path: root/synapse/storage/schema
diff options
context:
space:
mode:
authorErik Johnston <erik@matrix.org>2017-09-28 12:23:15 +0100
committerErik Johnston <erik@matrix.org>2017-09-28 12:23:15 +0100
commit77f1d24de3c696f52bc1ba6d0f61e82f03a9de7a (patch)
tree0e149f5440080386652c343d2c9cce6dd67ac625 /synapse/storage/schema
parentDelete expired url cache data (diff)
downloadsynapse-77f1d24de3c696f52bc1ba6d0f61e82f03a9de7a.tar.xz
More brackets
Diffstat (limited to 'synapse/storage/schema')
-rw-r--r--synapse/storage/schema/delta/44/expire_url_cache.sql2
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));