Make index unique

1 files changed, 1 insertions, 0 deletions

diff --git a/synapse/storage/profile.py b/synapse/storage/profile.py

index f60263502b..38524f2545 100644
--- a/synapse/storage/profile.py
+++ b/synapse/storage/profile.py
@@ -176,6 +176,7 @@ class ProfileStore(ProfileWorkerStore, background_updates.BackgroundUpdateStore)
             index_name="profile_replication_status_idx",
             table="profile_replication_status",
             columns=["host"],
+            unique=True,
         )
 
     def add_remote_profile_cache(self, user_id, displayname, avatar_url):