summary refs log tree commit diff
diff options
context:
space:
mode:
authorMark Haines <mark.haines@matrix.org>2016-03-16 10:35:00 +0000
committerMark Haines <mark.haines@matrix.org>2016-03-16 10:35:00 +0000
commitba660ecde20544ac1cfc163a5586f4f202627afa (patch)
treecbfab5eb50a6571be1a97815a49980976c7abf7b
parentFix a couple of errors when deleting pushers (diff)
downloadsynapse-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)
-rw-r--r--synapse/storage/schema/delta/30/deleted_pushers.sql1
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)
 );