ALTER TABLE `users` ADD `department` VARCHAR(50) NOT NULL AFTER `createdBy`, ADD `functionality` VARCHAR(2000) NOT NULL AFTER `department`

ALTER
 VIEW `expenditure_view`
 AS select `a`.`subhead` AS `subhead`,`b`.`description` AS `description`,`b`.`modeOfPayment` AS `modeOfPayment`,
 `b`.`acct` AS `acct`,`b`.`createdAt` AS `createdAt`,`b`.`debit` AS `amount`,`b`.`facilityId` AS `facilityId`,
 `b`.`client_acct` AS `client_acct`, enteredBy 
 from (`pscprim1_hms`.`account` `a` join `pscprim1_hms`.`transactions` `b`) 
 where ((`a`.`head` = `b`.`acct`) and (`a`.`subhead` = 'Expenditure'))