-- Add device_id to hr_biometric_logs
ALTER TABLE hr_biometric_logs ADD COLUMN device_id INT AFTER biometric_id;
ALTER TABLE hr_biometric_logs ADD FOREIGN KEY (device_id) REFERENCES hr_biometric_devices(id) ON DELETE SET NULL;