summary refs log tree commit diff
path: root/synapse/storage/schema/delta/21
diff options
context:
space:
mode:
authorErik Johnston <erik@matrix.org>2015-07-10 13:43:03 +0100
committerErik Johnston <erik@matrix.org>2015-07-10 13:43:03 +0100
commit0d7f0febf45575666d182cb2ad0cf451b11fbf07 (patch)
tree8979a7a2df80a58ff2e0ae31276d4f2145b36adc /synapse/storage/schema/delta/21
parentMerge pull request #198 from matrix-org/markjh/client-end-to-end-key-management (diff)
downloadsynapse-0d7f0febf45575666d182cb2ad0cf451b11fbf07.tar.xz
Uniquely name unique constraint
Diffstat (limited to 'synapse/storage/schema/delta/21')
-rw-r--r--synapse/storage/schema/delta/21/end_to_end_keys.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/synapse/storage/schema/delta/21/end_to_end_keys.sql b/synapse/storage/schema/delta/21/end_to_end_keys.sql
index 95e27eb7ea..8b4a380d11 100644
--- a/synapse/storage/schema/delta/21/end_to_end_keys.sql
+++ b/synapse/storage/schema/delta/21/end_to_end_keys.sql
@@ -19,7 +19,7 @@ CREATE TABLE IF NOT EXISTS e2e_device_keys_json (
     device_id TEXT NOT NULL, -- Which of the user's devices these keys are for.
     ts_added_ms BIGINT NOT NULL, -- When the keys were uploaded.
     key_json TEXT NOT NULL, -- The keys for the device as a JSON blob.
-    CONSTRAINT uniqueness UNIQUE (user_id, device_id)
+    CONSTRAINT e2e_device_keys_json_uniqueness UNIQUE (user_id, device_id)
 );
 
 
@@ -30,5 +30,5 @@ CREATE TABLE IF NOT EXISTS e2e_one_time_keys_json (
     key_id TEXT NOT NULL, -- An id for suppressing duplicate uploads.
     ts_added_ms BIGINT NOT NULL, -- When this key was uploaded.
     key_json TEXT NOT NULL, -- The key as a JSON blob.
-    CONSTRAINT uniqueness UNIQUE (user_id, device_id, algorithm, key_id)
+    CONSTRAINT e2e_one_time_keys_json_uniqueness UNIQUE (user_id, device_id, algorithm, key_id)
 );