-- Add unique constraint to payroll to prevent duplicates
ALTER TABLE hr_payroll ADD UNIQUE KEY employee_month_year (employee_id, payroll_month, payroll_year);