summary refs log tree commit diff
path: root/synapse/storage
diff options
context:
space:
mode:
authorAmber H. Brown <hawkowl@atleastfornow.net>2019-06-07 01:49:25 +1000
committerAmber H. Brown <hawkowl@atleastfornow.net>2019-06-07 01:49:25 +1000
commit837e32ef551b9c53d23615cdde56cc9babcc9059 (patch)
treef69c40d38e807d19d8057f0a96b564f7cd08067e /synapse/storage
parentremove background updates that arent needed (diff)
downloadsynapse-837e32ef551b9c53d23615cdde56cc9babcc9059.tar.xz
just user dir?
Diffstat (limited to 'synapse/storage')
-rw-r--r--synapse/storage/schema/full_schemas/54/stream_positions.sql20
1 files changed, 19 insertions, 1 deletions
diff --git a/synapse/storage/schema/full_schemas/54/stream_positions.sql b/synapse/storage/schema/full_schemas/54/stream_positions.sql
index 084a70db65..575ab6b354 100644
--- a/synapse/storage/schema/full_schemas/54/stream_positions.sql
+++ b/synapse/storage/schema/full_schemas/54/stream_positions.sql
@@ -4,4 +4,22 @@ INSERT INTO federation_stream_position (type, stream_id) VALUES ('federation', -
 INSERT INTO federation_stream_position (type, stream_id) SELECT 'events', coalesce(max(stream_ordering), -1) FROM events;
 INSERT INTO user_directory_stream_pos (stream_id) VALUES (null);
 INSERT INTO stats_stream_pos (stream_id) VALUES (null);
-INSERT INTO event_push_summary_stream_ordering (stream_ordering) VALUES (0);
\ No newline at end of file
+INSERT INTO event_push_summary_stream_ordering (stream_ordering) VALUES (0);
+
+--- User dir population
+
+-- Set up staging tables
+INSERT INTO background_updates (update_name, progress_json) VALUES
+    ('populate_user_directory_createtables', '{}');
+
+-- Run through each room and update the user directory according to who is in it
+INSERT INTO background_updates (update_name, progress_json, depends_on) VALUES
+    ('populate_user_directory_process_rooms', '{}', 'populate_user_directory_createtables');
+
+-- Insert all users, if search_all_users is on
+INSERT INTO background_updates (update_name, progress_json, depends_on) VALUES
+    ('populate_user_directory_process_users', '{}', 'populate_user_directory_process_rooms');
+
+-- Clean up staging tables
+INSERT INTO background_updates (update_name, progress_json, depends_on) VALUES
+    ('populate_user_directory_cleanup', '{}', 'populate_user_directory_process_users');