-- Migration: Add designation_id to assetloans
ALTER TABLE `assetloans` ADD COLUMN `designation_id` int(11) DEFAULT NULL AFTER `department_id`;
ALTER TABLE `assetloans` ADD KEY `idx_assetloans_designation_id` (`designation_id`);