-- SQL to add login attempt tracking columns to account table
-- Run this SQL in your database

ALTER TABLE `account` 
ADD COLUMN `login_attempts` INT(2) DEFAULT 0 AFTER `logins`,
ADD COLUMN `account_locked` TINYINT(1) DEFAULT 0 AFTER `login_attempts`,
ADD COLUMN `locked_at` DATETIME NULL AFTER `account_locked`;
