-- ---------------------------------------------------------------------
-- New table for MC Control
-- ---------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `mc_control` (
`id` int(10) unsigned NOT NULL auto_increment,
`created` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
`created_by` VARCHAR(64) NOT NULL,
`group` int(10) unsigned NULL,
`type` int(10) unsigned NULL,
`criticality` int(1) unsigned NULL,
`name` VARCHAR(64) NULL,
`mitigation_purpose` text NULL,
`mitigation_description` text NULL,
`mitigation_execution` text NULL,
`mitigation_parameters` text NULL,
`mitigation_documentation` text NULL,
`mitigation_reaction` text NULL,
`frequency` int(2) unsigned NULL,
`send_mail` boolean DEFAULT false,
`executer` VARCHAR(12) NULL,
`executer_mail` VARCHAR(64) NULL,
`owner` VARCHAR(12) NULL,
`owner_mail` VARCHAR(64) NULL,
`ac_risk` int(10) unsigned NULL,
PRIMARY KEY  (`id`));