-- Migration 0001: Add password_hash and webauthn_credentials columns to users table
-- Applied: 2026-04-19
-- Purpose: Support mandatory password + WebAuthn/Passkey auth for regular users (Task #91)

ALTER TABLE "users" ADD COLUMN IF NOT EXISTS "password_hash" varchar(255);
ALTER TABLE "users" ADD COLUMN IF NOT EXISTS "webauthn_credentials" jsonb;