-- ------------------------------------------------
-- DB updates for new SoD Roles
-- - enum for violations and mass generate
-- Created 20141219
-- ------------------------------------------------

ALTER TABLE `sod_preventive_check_violation`
  CHANGE COLUMN `rule_type` `rule_type` ENUM('crit_role','crit_tcode','sod_role','sod_func','sod_role2') NOT NULL ;

ALTER TABLE `sod_preventive_check` 
  CHANGE COLUMN `action` `action` ENUM('continue','cancel','massgen') NULL DEFAULT NULL ;
