-- Migration: Add role_id and designation_id columns to tbl_employees
-- This migration adds support for both roles and designations in the employee table

ALTER TABLE `tbl_employees` 
ADD COLUMN `role_id` INT(11) DEFAULT NULL COMMENT 'Link to roles table' AFTER `branch_id`,
ADD COLUMN `designation_id` INT(11) DEFAULT NULL COMMENT 'Link to tbl_designations' AFTER `role_id`;

-- Create indexes for better query performance
ALTER TABLE `tbl_employees` 
ADD KEY `idx_role_id` (`role_id`),
ADD KEY `idx_designation_id` (`designation_id`);
