ALTER TABLE projects 
ADD COLUMN work_region_type ENUM('local','outstation') DEFAULT 'local';

CREATE TABLE IF NOT EXISTS work_sessions (
    id INT AUTO_INCREMENT PRIMARY KEY,
    employee_id INT NOT NULL,
    project_id INT NOT NULL,
    work_date DATE NOT NULL,
    start_time DATETIME NOT NULL,
    end_time DATETIME NULL,
    hourly_rate DECIMAL(10,2) DEFAULT 0,
    work_type ENUM('local','outstation') DEFAULT 'local',
    notes TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
