Simon Wicky
46268edf9c
* one commit to rule them all * remove too aggressive copy pasting * update details when outdated * typo and serde alias * no hostname option and fixes * fix wasm client? * non fallback fixed * improve gateway details update * better ws addresses * PR review fixes * improve type safety on update_gateway_published_data * fix client gateway storage migration
23 lines
833 B
SQL
23 lines
833 B
SQL
/*
|
|
* Copyright 2025 - Nym Technologies SA <contact@nymtech.net>
|
|
* SPDX-License-Identifier: GPL-3.0-only
|
|
*/
|
|
|
|
|
|
-- make aes256gcm column non-nullable and drop any clients that still use the legacy keys
|
|
CREATE TABLE shared_keys_tmp
|
|
(
|
|
client_id INTEGER NOT NULL PRIMARY KEY REFERENCES clients (id),
|
|
client_address_bs58 TEXT NOT NULL UNIQUE,
|
|
derived_aes256_gcm_siv_key BLOB NOT NULL,
|
|
last_used_authentication TIMESTAMP WITHOUT TIME ZONE
|
|
);
|
|
|
|
INSERT INTO shared_keys_tmp (client_id, client_address_bs58, derived_aes256_gcm_siv_key, last_used_authentication)
|
|
SELECT client_id, client_address_bs58, derived_aes256_gcm_siv_key, last_used_authentication
|
|
FROM shared_keys
|
|
WHERE derived_aes256_gcm_siv_key IS NOT NULL;
|
|
|
|
DROP TABLE shared_keys;
|
|
ALTER TABLE shared_keys_tmp
|
|
RENAME TO shared_keys; |