summary refs log tree commit diff
path: root/synapse/storage/schema
diff options
context:
space:
mode:
authorErik Johnston <erik@matrix.org>2017-05-31 15:11:36 +0100
committerErik Johnston <erik@matrix.org>2017-05-31 15:11:36 +0100
commit350622a107c356da630eba09b63ed4b6de94b198 (patch)
treebfb6628b2b4271461a2a93c23ceaa1e45322defd /synapse/storage/schema
parentAdd comments (diff)
downloadsynapse-350622a107c356da630eba09b63ed4b6de94b198.tar.xz
Handle the server leaving a public room
Diffstat (limited to 'synapse/storage/schema')
-rw-r--r--synapse/storage/schema/delta/42/user_dir.py4
1 files changed, 4 insertions, 0 deletions
diff --git a/synapse/storage/schema/delta/42/user_dir.py b/synapse/storage/schema/delta/42/user_dir.py
index 57b89ba552..95a7a79fd3 100644
--- a/synapse/storage/schema/delta/42/user_dir.py
+++ b/synapse/storage/schema/delta/42/user_dir.py
@@ -41,6 +41,7 @@ CREATE TABLE user_directory (
 );
 
 CREATE INDEX user_directory_fts_idx ON user_directory USING gin(vector);
+CREATE INDEX user_directory_room_idx ON user_directory(room_id);
 CREATE INDEX user_directory_user_idx ON user_directory(user_id);
 """
 
@@ -48,6 +49,9 @@ CREATE INDEX user_directory_user_idx ON user_directory(user_id);
 SQLITE_TABLE = """
 CREATE VIRTUAL TABLE user_directory
     USING fts4 ( user_id, room_id, display_name, avatar_url, value );
+
+CREATE INDEX user_directory_room_idx ON user_directory(room_id);
+CREATE INDEX user_directory_user_idx ON user_directory(user_id);
 """