-- -------------------------------------- --
-- APM correcting earlier scripts 325-326
-- -------------------------------------- --
-- As stored procedures cannot be created 
-- through these script this script will
-- just provoke an update that will do the
-- following:
--
--	IF NOT EXISTS( 
--		(SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND COLUMN_NAME='proj_name' AND TABLE_NAME='cehior_auth_header')
--	) 
--		THEN ALTER TABLE cehior_auth_header ADD COLUMN `proj_name` varchar(20) NULL DEFAULT NULL AFTER `class`;
--
ALTER TABLE `cehior_auth_header` 
CHANGE COLUMN `proj_name` `proj_name` varchar(20) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci' NULL DEFAULT NULL;