-- -------------------------------------------- --
--  APM-3311 - AC, org level analysis, reports
--  Save field name for VARBL
-- -------------------------------------------- --
ALTER TABLE `sod_analysis_varbl` 
ADD COLUMN `field_name` VARCHAR(30) NOT NULL DEFAULT '' AFTER `varbl`,
DROP PRIMARY KEY,
ADD PRIMARY KEY (`system`, `client`, `varbl`, `field_name`);

-- --------------------------------------------------------- --
--  APM-3319 - AC, include reference users in user analysis
-- --------------------------------------------------------- --
ALTER TABLE `um_user` 
ADD COLUMN `ref_user` VARCHAR(12) NULL DEFAULT NULL AFTER `user_group`;
