summary refs log tree commit diff
diff options
context:
space:
mode:
authorErik Johnston <erik@matrix.org>2016-01-25 16:06:07 +0000
committerErik Johnston <erik@matrix.org>2016-01-25 16:06:07 +0000
commitce6fbbea94f0bbd50989f92dbf04c5204dad0795 (patch)
treed7c2f2c8e67d4a9caaa98022094ce0c055560033
parentMerge pull request #521 from matrix-org/erikj/underscores (diff)
parentAdd index to event_push_actions (diff)
downloadsynapse-ce6fbbea94f0bbd50989f92dbf04c5204dad0795.tar.xz
Merge pull request #526 from matrix-org/erikj/push_index
Add index to event_push_actions
Diffstat (limited to '')
-rw-r--r--synapse/storage/schema/delta/28/event_push_actions.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/synapse/storage/schema/delta/28/event_push_actions.sql b/synapse/storage/schema/delta/28/event_push_actions.sql
index bdf6ae3f24..4d519849df 100644
--- a/synapse/storage/schema/delta/28/event_push_actions.sql
+++ b/synapse/storage/schema/delta/28/event_push_actions.sql
@@ -24,3 +24,4 @@ CREATE TABLE IF NOT EXISTS event_push_actions(
 
 
 CREATE INDEX event_push_actions_room_id_event_id_user_id_profile_tag on event_push_actions(room_id, event_id, user_id, profile_tag);
+CREATE INDEX event_push_actions_room_id_user_id on event_push_actions(room_id, user_id);