mysql> show create table projects;
...
CREATE TABLE `projects` (
...
  `clientID` int(6) unsigned NOT NULL default '0',
  `clientInfoId` int(10) unsigned NOT NULL default '0',
...
  PRIMARY KEY  (`projectID`,`projectextension`),
  KEY `projectID` (`projectID`),
  KEY `clientID` (`clientID`),
  KEY `clientInfoId` (`clientInfoId`),
  KEY `enteredby` (`enteredby`),
  KEY `lastupdatedby` (`lastupdatedby`),
  KEY `approvedby` (`approvedby`),
  KEY `pmID` (`pmID`),
  CONSTRAINT `projects_ibfk_1` FOREIGN KEY (`clientID`) REFERENCES `clients` (`clientID`),
  CONSTRAINT `projects_ibfk_2` FOREIGN KEY (`clientInfoId`) REFERENCES `client_info` (`id`),
  CONSTRAINT `projects_ibfk_3` FOREIGN KEY (`enteredby`) REFERENCES `users` (`userID`),
  CONSTRAINT `projects_ibfk_4` FOREIGN KEY (`lastupdatedby`) REFERENCES `users` (`userID`),
  CONSTRAINT `projects_ibfk_5` FOREIGN KEY (`approvedby`) REFERENCES `users` (`userID`),
  CONSTRAINT `projects_ibfk_6` FOREIGN KEY (`pmID`) REFERENCES `users` (`userID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 | 

mysql> update projects set approved=1 where projectId = 131206;
ERROR 1364 (HY000): Field 'clientInfoId' doesn't have a default value