-- ---------------------------------------------------------------------
-- New table for IC_Check
-- ---------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `mc_check` (
`id` int(10) unsigned NOT NULL auto_increment,
`control` int(10) unsigned NULL,
`user` VARCHAR(12) NULL,
`owner` VARCHAR(12) NULL,
`mailed` boolean DEFAULT false,
`created` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY  (`id`));

-- ---------------------------------------------------------------------
-- New table for IC_CheckResponse
-- ---------------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `mc_check_response` (
`id` int(10) unsigned NOT NULL auto_increment,
`check` int(10) unsigned NULL,
`user` int(10) unsigned NULL,
`owner` VARCHAR(12) NULL,
`comment` text NULL,
`accepted` boolean DEFAULT false,
`positive` boolean DEFAULT false,
`timestamp` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY  (`id`));

-- ---------------------------------------------------------------------
-- New table for IC_CheckResponseFile
-- ---------------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `mc_check_response_file` (
`id` int(10) unsigned NOT NULL auto_increment,
`check_response` int(10) unsigned NULL,
`comment` text NULL,
`file` MEDIUMBLOB NULL,
`file_name` varchar(50) NULL,
`timestamp` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY  (`id`));