-- Add employee_type and category columns to salary_register table

ALTER TABLE salary_register 
ADD COLUMN IF NOT EXISTS employee_type VARCHAR(50) DEFAULT 'FTC' AFTER salary_month,
ADD COLUMN IF NOT EXISTS category VARCHAR(50) DEFAULT 'Skilled' AFTER employee_type;
