1 files changed, 12 insertions, 0 deletions
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);