Help with SQL code for new table - I get error

[gwmbox]

Hi guys

I am trying to create a table in a joomla install and the sql I am using to create the table is

DROP TABLE IF EXISTS `jos_teams2_fields_data`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `jos_teams2_fields_data` (
  `id` int(11) NOT NULL auto_increment,
  `fieldid` int(11) default NULL,
  `data_txt` text,
  `data_bool` tinyint(1) default NULL,
  `itemid` int(11) default NULL,
  `expiration` datetime default NULL,
  PRIMARY KEY  (`id`),
  KEY `FK_teams2_custom_fields_data_1` (`fieldid`),
  KEY `itemid` (`itemid`),
  KEY `field_item` (`fieldid`,`itemid`),
  CONSTRAINT `FK_teams_custom_fields_data_1` FOREIGN KEY (`fieldid`) REFERENCES `jos_teams2_fields` (`fieldid`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_teams_custom_fields_data_2` FOREIGN KEY (`itemid`) REFERENCES `jos_teams2_item` (`itemid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=141 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

I get an error of

#1005 - Can't create table './myDB_cms1/jos_teams2_fields_data.frm' (errno: 150)

I have no idea of what the error is caused by within the above sql statement and where to fix - please help.

I am trying to restore some mysql data from a backup and I was simply trying to run the sql I exported table by table and got as far as the above error.

Cheers