-- ----------------------------------------- --
-- APM-2984 AC, simulate role change
-- Need table to save violations temporarily
-- ----------------------------------------- --
CREATE TABLE `sod_simulation_violation` (
	`id` int NOT NULL AUTO_INCREMENT,
	`task_id` int NOT NULL,
	`rule_id` int NOT NULL,
	`username` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
	`causes_json` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
	`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
	PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;