-- Migration: Add IP address and user agent tracking to audit_logs
-- Run: mysql -u root dms_db < dms_audit_ip_migration.sql

ALTER TABLE audit_logs
  ADD COLUMN strIPAddress VARCHAR(45) DEFAULT NULL AFTER dtmAction,
  ADD COLUMN strUserAgent TEXT DEFAULT NULL AFTER strIPAddress;