work_donato

CREATE TABLE `overview_doc_entry_version` (  `item_type` char(1) NOT NULL,  `item_id` int(11) NOT NULL,  `version` int(11) default NULL,  `creator_id` int(11) NOT NULL,  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,  `status` char(1) NOT NULL,  `estimated_size` int(11) default NULL,  UNIQUE KEY `item_id_version` (`item_type`,`item_id`,`version`),  KEY `creator_id` (`creator_id`),  CONSTRAINT `overview_doc_entry_version_fk` FOREIGN KEY (`creator_id`) REFERENCES `user` (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1CREATE TABLE `acceptance_checklist` (  `id` int(11) NOT NULL auto_increment,  `request_id` int(11) NOT NULL,  `checklist_id` int(11) NOT NULL,  PRIMARY KEY  (`id`),  KEY `request_id` (`request_id`),  KEY `checklist_id` (`checklist_id`),  CONSTRAINT `acceptance_checklist_fk` FOREIGN KEY (`request_id`) REFERENCES `support_request` (`id`),  CONSTRAINT `acceptance_checklist_fk1` FOREIGN KEY (`checklist_id`) REFERENCES `checklist` (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1-- THIS NEXT TABLE RETURNS: ERROR 1005 (HY000): -- Can't create table './mytasks/overview_doc_item_version_acceptance_checklist.frm' (errno: 150)CREATE TABLE `overview_doc_item_version_acceptance_checklist` (  `item_type` char(1) not null,  `item_id` int(11) NOT NULL,  `version` int(11) NOT NULL,  `acceptance_checklist_id` int(11) NOT NULL,  PRIMARY KEY  (`item_type`, `item_id`, `version`, `acceptance_checklist_id`),  KEY `item_type` (`item_type`,`item_id`, `version`),  KEY `acceptance_checklist_id` (`acceptance_checklist_id`),  CONSTRAINT `odiv_acceptance_checklist_ibfk_1` FOREIGN KEY (`acceptance_checklist_id`) REFERENCES `acceptance_checklist` (`id`),  CONSTRAINT `odiv_acceptance_checklist_ibfk_2` FOREIGN KEY (`item_type`) REFERENCES `overview_doc_entry_version` (`item_type`, `item_id`, `version`)) ENGINE=InnoDB DEFAULT CHARSET=latin1This is the output of SHOW ENGINE INNODB STATUS\G------------------------LATEST FOREIGN KEY ERROR------------------------070509 15:12:48 Error in foreign key constraint of table mytasks/overview_doc_item_version_acceptance_checklist: FOREIGN KEY (`item_type`) REFERENCES `overview_doc_entry_version` (`item_type`, `item_id`, `version`)) ENGINE=InnoDB DEFAULT CHARSET=latin1:Syntax error close to:) ENGINE=InnoDB DEFAULT CHARSET=latin1