-- ------------------------------------------------
-- Add unique index to um_role_auth matching key of
-- transfer table in SAP
-- Created 20140917
-- ------------------------------------------------

TRUNCATE um_role_auth;

ALTER TABLE `um_role_auth` 
  ADD UNIQUE INDEX `sapkey` (`role_id` ASC, `object` ASC, `auth` ASC, `field` ASC, `low` ASC, `high` ASC);
