diff options
| author | Erik Johnston <erik@matrix.org> | 2016-12-07 09:58:33 +0000 |
|---|---|---|
| committer | Erik Johnston <erik@matrix.org> | 2016-12-07 09:58:33 +0000 |
| commit | 2687af82d4b63fbdc7597a46e0cec297cc660a51 (patch) | |
| tree | 526d7851228b2249e17688eb588b972c80f59403 /synapse/storage/schema/delta/39 | |
| parent | Don't include appservice id (diff) | |
| download | synapse-2687af82d4b63fbdc7597a46e0cec297cc660a51.tar.xz | |
Comments
Diffstat (limited to 'synapse/storage/schema/delta/39')
| -rw-r--r-- | synapse/storage/schema/delta/39/appservice_room_list.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/synapse/storage/schema/delta/39/appservice_room_list.sql b/synapse/storage/schema/delta/39/appservice_room_list.sql index 7e8344a577..74bdc49073 100644 --- a/synapse/storage/schema/delta/39/appservice_room_list.sql +++ b/synapse/storage/schema/delta/39/appservice_room_list.sql @@ -19,6 +19,8 @@ CREATE TABLE appservice_room_list( room_id TEXT NOT NULL ); +-- Each appservice can have multiple published room lists associated with them, +-- keyed of a particular network_id CREATE UNIQUE INDEX appservice_room_list_idx ON appservice_room_list( appservice_id, network_id, room_id ); |