mirror of
https://github.com/dani-garcia/vaultwarden.git
synced 2026-11-11 00:29:17 -05:00
14 lines
620 B
SQL
14 lines
620 B
SQL
ALTER TABLE users ADD COLUMN signed_public_key TEXT;
|
|
ALTER TABLE users ADD COLUMN security_state TEXT;
|
|
ALTER TABLE users ADD COLUMN security_version INTEGER;
|
|
|
|
CREATE TABLE user_signature_key_pairs (
|
|
uuid CHAR(36) NOT NULL PRIMARY KEY,
|
|
user_uuid CHAR(36) NOT NULL UNIQUE,
|
|
signature_algorithm INTEGER NOT NULL, -- 0 = ed25519, 1 = mldsa44
|
|
signing_key TEXT NOT NULL,
|
|
verifying_key TEXT NOT NULL,
|
|
created_at DATETIME NOT NULL,
|
|
updated_at DATETIME NOT NULL,
|
|
FOREIGN KEY (user_uuid) REFERENCES users (uuid) ON DELETE CASCADE
|
|
);
|