-- -------------------------------------------------- --
-- APM-2952 IC, control template, upload of documents
-- Need table to save files
-- -------------------------------------------------- --
CREATE TABLE IF NOT EXISTS `ic_control_file` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `control_id` int(11) NOT NULL,
  `username` varchar(12) NOT NULL,
  `file_description` text,
  `file_name` tinytext,
  `file_type` text,
  `file` mediumblob,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`));
  