From 0e892bda4e0bf9db9116d7d5585d4e7b0d2eae57 Mon Sep 17 00:00:00 2001 From: Werner Koch Date: Tue, 22 Sep 2020 15:42:12 +0200 Subject: keyboxd: Extend PUBKEY_INFO status line with an uid ordinal. * kbx/backend-sqlite.c (table_definitions): Add column UINO to userids. (be_sqlite_local_s): Add fields select_col_uidno and select_col_subkey. (run_select_statement): Also select subkey or uidno column. (be_sqlite_search): Return their values. (store_into_userid): Store the UIDNO. * kbx/backend-support.c (be_return_pubkey): Extend PUBKEY_INFO. -- For an existing database adding the new column to the table userid is straightforward. However if the original version of the schema used an integer for the keyid column, that column has likely be renamed. Make sure that the NOT NULL constraint has also be removed; check the SQLite documentation on how this can be done. Signed-off-by: Werner Koch --- kbx/backend-cache.c | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'kbx/backend-cache.c') diff --git a/kbx/backend-cache.c b/kbx/backend-cache.c index c52bcc5de..f30fa7dcb 100644 --- a/kbx/backend-cache.c +++ b/kbx/backend-cache.c @@ -1016,7 +1016,8 @@ be_cache_search (ctrl_t ctrl, backend_handle_t backend_hd, db_request_t request, if (b) { err = be_return_pubkey (ctrl, b->data, b->datalen, - b->pktype, desc[n].u.ubid, 0, 0); + b->pktype, desc[n].u.ubid, + 0, 0, 0, 0); blob_unref (b); reqpart->cache_seqno.ubid++; } @@ -1058,7 +1059,7 @@ be_cache_search (ctrl_t ctrl, backend_handle_t backend_hd, db_request_t request, if (b) { err = be_return_pubkey (ctrl, b->data, b->datalen, - PUBKEY_TYPE_OPGP, bl->ubid, 0, 0); + PUBKEY_TYPE_OPGP, bl->ubid, 0, 0, 0, 0); blob_unref (b); } else -- cgit v1.2.3