MySQL Lies to Me

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