diff options
| author | Erik Johnston <erik@matrix.org> | 2015-04-15 16:53:47 +0100 |
|---|---|---|
| committer | Erik Johnston <erik@matrix.org> | 2015-04-15 16:53:47 +0100 |
| commit | cf04cedf216a21f36a476703470b7ffe1a727967 (patch) | |
| tree | b19d7d4d6198c629453c14edb7560791c94d41b5 /synapse/storage/schema/delta | |
| parent | Remove debug logging (diff) | |
| download | synapse-cf04cedf216a21f36a476703470b7ffe1a727967.tar.xz | |
Change full_schemas/11 to work with postgres
Diffstat (limited to 'synapse/storage/schema/delta')
| -rw-r--r-- | synapse/storage/schema/delta/16/events_order_index.sql | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/synapse/storage/schema/delta/16/events_order_index.sql b/synapse/storage/schema/delta/16/events_order_index.sql index c015414663..a48f215170 100644 --- a/synapse/storage/schema/delta/16/events_order_index.sql +++ b/synapse/storage/schema/delta/16/events_order_index.sql @@ -1 +1,4 @@ -CREATE INDEX events_order ON events (topological_ordering, stream_ordering); \ No newline at end of file +CREATE INDEX events_order ON events (topological_ordering, stream_ordering); +CREATE INDEX events_order_room ON events ( + room_id, topological_ordering, stream_ordering +); |