-- Add shift_id to employees table
ALTER TABLE `employees` ADD `shift_id` INT(11) NULL DEFAULT NULL AFTER `designation`;
ALTER TABLE `employees` ADD FOREIGN KEY (`shift_id`) REFERENCES `shifts`(`id`);