3 lines
160 B
SQL
3 lines
160 B
SQL
-- Add unique constraint to payroll to prevent duplicates
|
|
ALTER TABLE hr_payroll ADD UNIQUE KEY employee_month_year (employee_id, payroll_month, payroll_year);
|