From 0a1001eb0bd2d1f7c0624ae1ef8ae7ccdb3447d4 Mon Sep 17 00:00:00 2001 From: Peter Stone Date: Thu, 5 Feb 2026 15:35:01 -1000 Subject: Add passkey (WebAuthn) authentication support MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Enable passwordless login via passkeys as an alternative to password auth. Users register passkeys from Settings; the login page offers both options. WebAuthn is optional — only active when WEBAUTHN_RP_ID and WEBAUTHN_ORIGIN env vars are set. Co-Authored-By: Claude Opus 4.6 --- migrations/014_webauthn_credentials.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 migrations/014_webauthn_credentials.sql (limited to 'migrations/014_webauthn_credentials.sql') diff --git a/migrations/014_webauthn_credentials.sql b/migrations/014_webauthn_credentials.sql new file mode 100644 index 0000000..d1abefc --- /dev/null +++ b/migrations/014_webauthn_credentials.sql @@ -0,0 +1,12 @@ +CREATE TABLE IF NOT EXISTS webauthn_credentials ( + id TEXT PRIMARY KEY, + user_id INTEGER NOT NULL REFERENCES users(id), + public_key BLOB NOT NULL, + attestation_type TEXT NOT NULL, + aaguid BLOB, + sign_count INTEGER DEFAULT 0, + name TEXT DEFAULT '', + created_at DATETIME DEFAULT CURRENT_TIMESTAMP, + FOREIGN KEY (user_id) REFERENCES users(id) +); +CREATE INDEX IF NOT EXISTS idx_webauthn_user ON webauthn_credentials(user_id); -- cgit v1.2.3