-- Migration: Add role_id column to tbl_employees
-- This migration adds support for roles in the employee table

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

-- Create index on role_id for better query performance
ALTER TABLE `tbl_employees` 
ADD KEY `idx_role_id` (`role_id`);
