-- Run this SQL script in your MySQL database
-- Database: demigrou_attendpro

USE demigrou_attendpro;

-- Add unrecorded_leave column if it doesn't exist
ALTER TABLE leave_entitled 
ADD COLUMN IF NOT EXISTS unrecorded_leave DECIMAL(5,2) DEFAULT 0 AFTER TS;

-- Verify the column was added
DESCRIBE leave_entitled;
