diff options
| author | Matthew Hodgson <matthew@matrix.org> | 2014-11-13 11:58:54 +0200 |
|---|---|---|
| committer | Matthew Hodgson <matthew@matrix.org> | 2014-11-13 11:58:54 +0200 |
| commit | 28408a9f64dc889078711b0e2bae5cff4c90c91e (patch) | |
| tree | 35ea17e51de82925f171bb15d4b9876d67b3bf9c /synapse/storage/schema/state.sql | |
| parent | various fixes based on truphone feedback (diff) | |
| parent | Detect OpenWebRTC and add workarounds, but comment out the turn server remova... (diff) | |
| download | synapse-28408a9f64dc889078711b0e2bae5cff4c90c91e.tar.xz | |
Merge branch 'develop' of git+ssh://github.com/matrix-org/synapse into develop
Diffstat (limited to 'synapse/storage/schema/state.sql')
| -rw-r--r-- | synapse/storage/schema/state.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/synapse/storage/schema/state.sql b/synapse/storage/schema/state.sql index b44c56b519..44f7aafb27 100644 --- a/synapse/storage/schema/state.sql +++ b/synapse/storage/schema/state.sql @@ -30,4 +30,17 @@ CREATE TABLE IF NOT EXISTS state_groups_state( CREATE TABLE IF NOT EXISTS event_to_state_groups( event_id TEXT NOT NULL, state_group INTEGER NOT NULL +); + +CREATE INDEX IF NOT EXISTS state_groups_id ON state_groups(id); + +CREATE INDEX IF NOT EXISTS state_groups_state_id ON state_groups_state( + state_group +); +CREATE INDEX IF NOT EXISTS state_groups_state_tuple ON state_groups_state( + room_id, type, state_key +); + +CREATE INDEX IF NOT EXISTS event_to_state_groups_id ON event_to_state_groups( + event_id ); \ No newline at end of file |