diff options
| author | Erik Johnston <erik@matrix.org> | 2017-09-26 15:39:13 +0100 |
|---|---|---|
| committer | Erik Johnston <erik@matrix.org> | 2017-09-26 15:39:21 +0100 |
| commit | a8e2a3df32f3584d728021d5feafecf78b0f37d1 (patch) | |
| tree | bc03b29b34019d66d26f08f642863a769e240e26 /synapse/storage/schema | |
| parent | Merge pull request #2471 from matrix-org/erikj/group_summary_publicised (diff) | |
| download | synapse-a8e2a3df32f3584d728021d5feafecf78b0f37d1.tar.xz | |
Add unique index to group_rooms table
Diffstat (limited to 'synapse/storage/schema')
| -rw-r--r-- | synapse/storage/schema/delta/43/group_server.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/synapse/storage/schema/delta/43/group_server.sql b/synapse/storage/schema/delta/43/group_server.sql index e74554381f..b2333848a0 100644 --- a/synapse/storage/schema/delta/43/group_server.sql +++ b/synapse/storage/schema/delta/43/group_server.sql @@ -52,7 +52,7 @@ CREATE TABLE group_rooms ( is_public BOOLEAN NOT NULL -- whether the room can be seen by everyone ); -CREATE INDEX groups_rooms_g_idx ON group_rooms(group_id, room_id); +CREATE UNIQUE INDEX groups_rooms_g_idx ON group_rooms(group_id, room_id); CREATE INDEX groups_rooms_r_idx ON group_rooms(room_id); |