-- Migration: Add TOTP two-factor authentication support
-- Run this against your existing database

USE BeezifiIOM;

ALTER TABLE users
    ADD COLUMN IF NOT EXISTS totp_secret  VARCHAR(64) NULL                     AFTER password_hash,
    ADD COLUMN IF NOT EXISTS totp_enabled BOOLEAN NOT NULL DEFAULT FALSE       AFTER totp_secret;
