Bogdan-Ștefan Neacşu
bd94dd3055
* Store wireguard peers in db * Add update to nym-node * Move gateway-requests and gateway-storage to common * Carry storage to PeerController field * Double kernel modifications with storage ones * Take storage peers at boot * Link storage query for registration flow * Move authenticator peer comms in peer manager * Modify template too * Remove unused * Fix clippy * Fix clippy non-linux * Keep storage data up-to-date on every check * Check for staleness in storage timestamps * Remove potential for panic in unwrap * Fix clippy * Fmt * Clippy after rebase * Remove in memory test structure
25 lines
692 B
SQL
25 lines
692 B
SQL
/*
|
|
* Copyright 2021 - Nym Technologies SA <contact@nymtech.net>
|
|
* SPDX-License-Identifier: Apache-2.0
|
|
*/
|
|
|
|
CREATE TABLE shared_keys
|
|
(
|
|
client_address_bs58 TEXT NOT NULL PRIMARY KEY UNIQUE,
|
|
derived_aes128_ctr_blake3_hmac_keys_bs58 TEXT NOT NULL
|
|
);
|
|
|
|
CREATE TABLE message_store
|
|
(
|
|
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
|
client_address_bs58 TEXT NOT NULL,
|
|
content BLOB NOT NULL
|
|
);
|
|
|
|
CREATE TABLE available_bandwidth
|
|
(
|
|
client_address_bs58 TEXT NOT NULL PRIMARY KEY UNIQUE,
|
|
available INTEGER NOT NULL
|
|
);
|
|
|
|
CREATE INDEX `message_store_index` ON `message_store` (`client_address_bs58`, `content`); |