mirror of
https://github.com/dani-garcia/vaultwarden.git
synced 2026-11-12 09:09:18 -05:00
15 lines
709 B
SQL
15 lines
709 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;
|
|
ALTER TABLE users ADD COLUMN v2_upgrade_token TEXT;
|
|
ALTER TABLE users_organizations ADD COLUMN v2_upgrade_token TEXT;
|
|
|
|
CREATE TABLE user_signature_key_pairs (
|
|
uuid TEXT NOT NULL PRIMARY KEY,
|
|
user_uuid TEXT NOT NULL UNIQUE REFERENCES users (uuid) ON DELETE CASCADE,
|
|
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
|
|
);
|