-- ------------------------------------------------
-- ADDING role2 risk/rule type to ENUM columns
-- Created 20150119
-- ------------------------------------------------

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

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

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

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