diff options
| author | Mark Haines <mark.haines@matrix.org> | 2016-03-16 10:35:00 +0000 |
|---|---|---|
| committer | Mark Haines <mark.haines@matrix.org> | 2016-03-16 10:35:00 +0000 |
| commit | ba660ecde20544ac1cfc163a5586f4f202627afa (patch) | |
| tree | cbfab5eb50a6571be1a97815a49980976c7abf7b /synapse/storage/schema/delta/30 | |
| parent | Fix a couple of errors when deleting pushers (diff) | |
| download | synapse-ba660ecde20544ac1cfc163a5586f4f202627afa.tar.xz | |
Add a comment to offer a hint to an explanation for why we have a unique constraint on (app_id, pushkey, user_id)
Diffstat (limited to 'synapse/storage/schema/delta/30')
| -rw-r--r-- | synapse/storage/schema/delta/30/deleted_pushers.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/synapse/storage/schema/delta/30/deleted_pushers.sql b/synapse/storage/schema/delta/30/deleted_pushers.sql index cdcf79ac81..712c454aa1 100644 --- a/synapse/storage/schema/delta/30/deleted_pushers.sql +++ b/synapse/storage/schema/delta/30/deleted_pushers.sql @@ -18,6 +18,7 @@ CREATE TABLE IF NOT EXISTS deleted_pushers( app_id TEXT NOT NULL, pushkey TEXT NOT NULL, user_id TEXT NOT NULL, + /* We only track the most recent delete for each app_id, pushkey and user_id. */ UNIQUE (app_id, pushkey, user_id) ); |