--
-- Database: `InstiKit`
--

-- --------------------------------------------------------

--
-- InstiKit 4.7.0 post update queries
--

START TRANSACTION;


ALTER TABLE `timetable_allocations` ADD `employee_id` BIGINT UNSIGNED NULL DEFAULT NULL AFTER `subject_id`, ADD INDEX `employee_id` (`employee_id`);
ALTER TABLE `timetable_allocations` ADD CONSTRAINT `timetable_allocations_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees`(`id`) ON DELETE SET NULL ON UPDATE RESTRICT;


COMMIT;