ALTER TABLE `LoanAccountDecline` DROP FOREIGN KEY `LoanAccountDecline_ibfk_1` ;
ALTER TABLE `LoanAccountDecline` CHANGE COLUMN `account_id` `account_id` MEDIUMINT UNSIGNED NOT NULL  , 
  ADD CONSTRAINT `LoanAccountDecline_ibfk_1`
  FOREIGN KEY (`account_id` )
  REFERENCES `LoanAccount` (`id` )
  ON DELETE NO ACTION
  ON UPDATE CASCADE;
update AuthItem set name = replace(name, 'LoanAccount', 'Loan') where name like 'LoanAccount%';
