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
ALTER TABLE `profilefield` ADD`profilefieldcategoryid` smallint(5) unsigned NOT NULL