This should fix your issue:
Code:
CREATE TABLE `profilefieldcategory` (
`profilefieldcategoryid` smallint(5) unsigned NOT NULL auto_increment,
`displayorder` smallint(5) unsigned NOT NULL,
PRIMARY KEY (`profilefieldcategoryid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
and then..
Code:
ALTER TABLE `profilefield` ADD`profilefieldcategoryid` smallint(5) unsigned NOT NULL