-- -------------------------------------------------
--  Create table for AC dashboard approved_mitigated
-- -------------------------------------------------
CREATE TABLE IF NOT EXISTS `sod_dashboard_approved_mitigated` (
	date DATE NOT NULL,
	`system` VARCHAR(8) NOT NULL,
	client VARCHAR(3) NOT NULL,
	
	approved_mitigated INT NOT NULL,
	approved_non_mitigated INT NOT NULL,
 	non_approved_mitigated INT NOT NULL,
	non_approved_non_mitigated INT NOT NULL,

PRIMARY KEY (date, `system`, client));
