CREATE TABLE IF NOT EXISTS `ClickTrackPluginStat` ( 
`Id` int(11) NOT NULL AUTO_INCREMENT, 
`EntityName` VARCHAR(200) NOT NULL,
`EntityId` INT NOT NULL,
`StateType` VARCHAR(200) NOT NULL,
`DateCreated` DATE NULL ,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB  DEFAULT CHARACTER SET `utf8`; 


CREATE TABLE IF NOT EXISTS `ClickTrackPluginMessage` ( 
`Id` int(11) NOT NULL AUTO_INCREMENT, 
`EntityName` VARCHAR(200) NOT NULL,
`EntityId` INT NOT NULL,
`DateCreated` DATE NULL ,
`FirstName` VARCHAR(200) NOT NULL,
`Name` VARCHAR(200) NOT NULL,
`Email` VARCHAR(200) NOT NULL,
`Phone` VARCHAR(200) NOT NULL,
`Message` VARCHAR(1000)  NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB  DEFAULT CHARACTER SET `utf8`; 
