CREATE TABLE IF NOT EXISTS `CrmBusiness` ( 
`Id` int(11) NOT NULL AUTO_INCREMENT, 
`Name` VARCHAR(200)  NOT NULL,
`Code` VARCHAR(200)  NOT NULL,
`Description` TEXT  NOT NULL,
`TypeId` INT  NOT NULL,
`StatutId` INT  NOT NULL,
`ProspectId` INT  NOT NULL,
PRIMARY KEY (`Id`),
CONSTRAINT `CrmBusinessType_CrmBusiness` FOREIGN KEY (`TypeId`) REFERENCES `CrmBusinessType`(`Id`),
CONSTRAINT `CrmBusinessStatut_CrmBusiness` FOREIGN KEY (`StatutId`) REFERENCES `CrmBusinessStatut`(`Id`),
CONSTRAINT `CrmProspect_CrmBusiness` FOREIGN KEY (`ProspectId`) REFERENCES `CrmProspect`(`Id`)
) ENGINE=InnoDB  DEFAULT CHARACTER SET `utf8`; 