-- ----------------------------------------------------- --
-- AC dashboard, table for weighted user risks per group
-- ----------------------------------------------------- --
CREATE TABLE `sod_dashboard_groupcount_users_weighted` (
	`date` date NOT NULL,
	`system` char(3) NOT NULL,
	`client` char(3) NOT NULL,
	`group_id` int NOT NULL,
	`rule_type` enum('crit_role','crit_tcode','sod_role','sod_role2','sod_func') NOT NULL,
	`count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`date`, `system`, `client`, `group_id`, `rule_type`)
) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------------------------------- --
-- APM, expand how long a password can be for a testuser
-- ----------------------------------------------------- --
ALTER TABLE `cehior_auth_proj_test_user` 
CHANGE COLUMN `pw` `pw` VARCHAR(40) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci' NULL DEFAULT NULL ;
