diff options
author | Erik Johnston <erik@matrix.org> | 2015-07-10 13:43:03 +0100 |
---|---|---|
committer | Erik Johnston <erik@matrix.org> | 2015-07-10 13:43:03 +0100 |
commit | 0d7f0febf45575666d182cb2ad0cf451b11fbf07 (patch) | |
tree | 8979a7a2df80a58ff2e0ae31276d4f2145b36adc /synapse/storage/schema/delta/21 | |
parent | Merge pull request #198 from matrix-org/markjh/client-end-to-end-key-management (diff) | |
download | synapse-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.sql | 4 |
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) ); |