-- Migration: Add IP Address and Browser Tracking
-- Date: 2026-01-19

USE dokumentasi;

-- Add new columns to dokumentasi table
ALTER TABLE dokumentasi 
ADD COLUMN ip_address VARCHAR(45) AFTER timestamp,
ADD COLUMN browser_info VARCHAR(500) AFTER ip_address;

-- Add index for IP address queries (optional)
ALTER TABLE dokumentasi ADD INDEX idx_ip_address (ip_address);