CREATE TABLE IF NOT EXISTS `CalendarEventUser` ( 
`Id` int(11) NOT NULL AUTO_INCREMENT, 
`EventId` INT  NOT NULL,
`UserId` INT NULL,
`Name` TEXT  NOT NULL,
`FirstName` TEXT  NOT NULL,
`Email` TEXT  NOT NULL,
`Phone` TEXT  NOT NULL,
PRIMARY KEY (`Id`),
CONSTRAINT `CalendarEvent_CalendarEventUser` FOREIGN KEY (`EventId`) REFERENCES `CalendarEvent`(`Id`)
) ENGINE=InnoDB  DEFAULT CHARACTER SET `utf8`; 