diff options
| author | Neil Alexander <neilalexander@users.noreply.github.com> | 2022-05-09 11:13:04 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2022-05-09 11:13:04 +0100 |
| commit | 4c15c73b3abfb0cca0c95c7a21305a8329e2c23c (patch) | |
| tree | 8ce63986059a65d9b08cb64a9d2d4f06398a76ed /keyserver/storage | |
| parent | 633ca06eb9f7652a6c4be04b3ffe8950419a8ee3 (diff) | |
Add `(user_id, device_id)` index on OTK table (#2435)
Diffstat (limited to 'keyserver/storage')
| -rw-r--r-- | keyserver/storage/postgres/one_time_keys_table.go | 2 | ||||
| -rw-r--r-- | keyserver/storage/sqlite3/one_time_keys_table.go | 2 |
2 files changed, 4 insertions, 0 deletions
diff --git a/keyserver/storage/postgres/one_time_keys_table.go b/keyserver/storage/postgres/one_time_keys_table.go index 0b143a1a..d8c76b49 100644 --- a/keyserver/storage/postgres/one_time_keys_table.go +++ b/keyserver/storage/postgres/one_time_keys_table.go @@ -39,6 +39,8 @@ CREATE TABLE IF NOT EXISTS keyserver_one_time_keys ( -- Clobber based on 4-uple of user/device/key/algorithm. CONSTRAINT keyserver_one_time_keys_unique UNIQUE (user_id, device_id, key_id, algorithm) ); + +CREATE INDEX IF NOT EXISTS keyserver_one_time_keys_idx ON keyserver_one_time_keys (user_id, device_id); ` const upsertKeysSQL = "" + diff --git a/keyserver/storage/sqlite3/one_time_keys_table.go b/keyserver/storage/sqlite3/one_time_keys_table.go index 897839ac..d2c0b7b2 100644 --- a/keyserver/storage/sqlite3/one_time_keys_table.go +++ b/keyserver/storage/sqlite3/one_time_keys_table.go @@ -38,6 +38,8 @@ CREATE TABLE IF NOT EXISTS keyserver_one_time_keys ( -- Clobber based on 4-uple of user/device/key/algorithm. UNIQUE (user_id, device_id, key_id, algorithm) ); + +CREATE INDEX IF NOT EXISTS keyserver_one_time_keys_idx ON keyserver_one_time_keys (user_id, device_id); ` const upsertKeysSQL = "" + |