CREATE TABLE `reports` (
 `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
 `period` date NOT NULL,
 `type` tinyint(3) unsigned NOT NULL,
 `project` tinyint(3) unsigned NOT NULL,
 `status` enum('g','y','r') COLLATE utf8_swedish_ci NOT NULL,
 `report` text COLLATE utf8_swedish_ci NOT NULL,
 PRIMARY KEY (`id`),
  foreign key (type) references types(id),
  foreign key (project) references projects(id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci