-- ============================================================
-- 052 — PIN de firma digital para usuarios médicos
-- ============================================================

ALTER TABLE users
    ADD COLUMN signing_pin            VARCHAR(255)  NULL     AFTER password_hash,
    ADD COLUMN signing_pin_attempts   TINYINT       NOT NULL DEFAULT 0 AFTER signing_pin,
    ADD COLUMN signing_pin_locked_until DATETIME    NULL     AFTER signing_pin_attempts;