diff options
| author | Mark Haines <mark.haines@matrix.org> | 2016-09-12 11:00:26 +0100 |
|---|---|---|
| committer | Mark Haines <mark.haines@matrix.org> | 2016-09-12 11:00:26 +0100 |
| commit | 31f85f9db9d78ce2e201e7adb7128131377b376d (patch) | |
| tree | f0350f50699a3359999e87bf6143e29a98415d16 /synapse/storage/schema/delta/29 | |
| parent | Merge pull request #1102 from matrix-org/revert-1099-dbkr/make_notif_highligh... (diff) | |
| download | synapse-31f85f9db9d78ce2e201e7adb7128131377b376d.tar.xz | |
Add comments to existing schema deltas that used "CREATE INDEX" directly
Diffstat (limited to 'synapse/storage/schema/delta/29')
| -rw-r--r-- | synapse/storage/schema/delta/29/push_actions.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/synapse/storage/schema/delta/29/push_actions.sql b/synapse/storage/schema/delta/29/push_actions.sql index 7e7b09820a..84b21cf813 100644 --- a/synapse/storage/schema/delta/29/push_actions.sql +++ b/synapse/storage/schema/delta/29/push_actions.sql @@ -26,6 +26,10 @@ UPDATE event_push_actions SET stream_ordering = ( UPDATE event_push_actions SET notif = 1, highlight = 0; +/** Using CREATE INDEX directly is deprecated in favour of using background + * update see synapse/storage/schema/delta/33/access_tokens_device_index.sql + * and synapse/storage/registration.py for an example using + * "access_tokens_device_index" **/ CREATE INDEX event_push_actions_rm_tokens on event_push_actions( user_id, room_id, topological_ordering, stream_ordering ); |