-- ------------------------------------------------
-- Changed PK on um_profile to reflect SAP data
-- Created 20150220
-- ------------------------------------------------

ALTER TABLE `um_profile` 
  CHANGE COLUMN `type` `type` CHAR(1) NOT NULL DEFAULT '',
  DROP PRIMARY KEY,
  ADD PRIMARY KEY (`system`, `client`, `profile`, `type`);
