diff options
| author | Erik Johnston <erik@matrix.org> | 2015-04-07 12:09:36 +0100 |
|---|---|---|
| committer | Erik Johnston <erik@matrix.org> | 2015-04-07 12:09:36 +0100 |
| commit | 8574bf62dc27ec3c2059c57a32c955e85d7e51df (patch) | |
| tree | e0064f5d9052b07eaf49f94c36266559b18b6cb1 /synapse/storage/schema/delta/15 | |
| parent | Don't use multiple UNIQUE constraints; it will cause deadlocks (diff) | |
| download | synapse-8574bf62dc27ec3c2059c57a32c955e85d7e51df.tar.xz | |
Add index to presence table
Diffstat (limited to 'synapse/storage/schema/delta/15')
| -rw-r--r-- | synapse/storage/schema/delta/15/presence_indices.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/synapse/storage/schema/delta/15/presence_indices.sql b/synapse/storage/schema/delta/15/presence_indices.sql new file mode 100644 index 0000000000..6b8d0f1ca7 --- /dev/null +++ b/synapse/storage/schema/delta/15/presence_indices.sql @@ -0,0 +1,2 @@ + +CREATE INDEX IF NOT EXISTS presence_list_user_id ON presence_list (user_id); |