CREATE TABLE IF NOT EXISTS `AssoMember` ( 
`Id` int(11) NOT NULL AUTO_INCREMENT, 
`FirstName` TEXT  NOT NULL,
`Name` TEXT  NOT NULL,
`Email` TEXT NULL,
`Phone` TEXT NULL,
`Adress` TEXT  NULL,
`ZipCode` TEXT  NULL,
`City` TEXT  NULL,
`BirthDate` Date NULL,
`MemberTypeId` INT  NOT NULL,
`UserId` INT NULL,
`DateCreated` Date  NOT NULL,
`Status` INT  NULL,
PRIMARY KEY (`Id`),
CONSTRAINT `AssoMemberType_AssoMember` FOREIGN KEY (`MemberTypeId`) REFERENCES `AssoMemberType`(`Id`)
) ENGINE=InnoDB  DEFAULT CHARACTER SET `utf8`; 