CREATE TABLE IF NOT EXISTS `BookingCaracteristique` ( 
`Id` int(11) NOT NULL AUTO_INCREMENT, 
`Name` VARCHAR(200)  NOT NULL,
`Description` TEXT  NOT NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB  DEFAULT CHARACTER SET `utf8`; 

CREATE TABLE IF NOT EXISTS `BookingCaracteristiqueItem` ( 
`Id` int(11) NOT NULL AUTO_INCREMENT, 
`CaracteristiqueId` INT  NOT NULL,
`Label` TEXT  NOT NULL,
PRIMARY KEY (`Id`),
CONSTRAINT `BookingCaracteristique_BookingCaracteristiqueItem` FOREIGN KEY (`CaracteristiqueId`) REFERENCES `BookingCaracteristique`(`Id`)
) ENGINE=InnoDB  DEFAULT CHARACTER SET `utf8`; 

CREATE TABLE IF NOT EXISTS `BookingReservation` ( 
`Id` int(11) NOT NULL AUTO_INCREMENT, 
`Name` TEXT  NOT NULL,
`FirstName` TEXT  NOT NULL,
`Email` TEXT  NOT NULL,
`Tel` TEXT  NOT NULL,
`DateStart` DATE  NOT NULL,
`DateEnd` TEXT  NOT NULL,
`Status` INT  NOT NULL,
`Data` TEXT NULL,
`UserId` INT  NULL,
`AppName` VARCHAR(200)  NULL ,
`AppId` INT  NULL ,
`EntityName` VARCHAR(200)  NULL ,
`EntityId` INT  NULL ,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB  DEFAULT CHARACTER SET `utf8`; 

CREATE TABLE IF NOT EXISTS `BookingOpeningTime` ( 
`Id` int(11) NOT NULL AUTO_INCREMENT, 
`Day` INT  NOT NULL,
`HourStartAm` TIME  NULL,
`HourEndAm` TIME  NULL,
`HourStartPm` TIME  NULL,
`HourEndPm` TIME  NULL,
`DateExtra` DATE  NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB  DEFAULT CHARACTER SET `utf8`; 