summary refs log tree commit diff
diff options
context:
space:
mode:
authorErik Johnston <erik@matrix.org>2015-07-02 13:18:41 +0100
committerErik Johnston <erik@matrix.org>2015-07-02 13:18:41 +0100
commitac78e60de6fd2e409d6abd806e8850d539bbe644 (patch)
treeff048af0f020b4f2e2c7560f863b8f2aa99fc158
parentConsolidate duplicate code in notifier (diff)
downloadsynapse-ac78e60de6fd2e409d6abd806e8850d539bbe644.tar.xz
Add stream_id index
-rw-r--r--synapse/storage/schema/delta/21/receipts.sql6
1 files changed, 5 insertions, 1 deletions
diff --git a/synapse/storage/schema/delta/21/receipts.sql b/synapse/storage/schema/delta/21/receipts.sql
index ccd64ec7f4..ac7738e371 100644
--- a/synapse/storage/schema/delta/21/receipts.sql
+++ b/synapse/storage/schema/delta/21/receipts.sql
@@ -33,6 +33,10 @@ CREATE TABLE IF NOT EXISTS receipts_linearized (
     event_id TEXT NOT NULL
 );
 
-CREATE INDEX receipts_linearized_room_tuple ON receipts_graph(
+CREATE INDEX receipts_linearized_room_tuple ON receipts_linearized(
   room_id, receipt_type, user_id
 );
+
+CREATE INDEX receipts_linearized_id ON receipts_linearized(
+  stream_id
+);