CREATE TABLE IF NOT EXISTS `ImmoCity` ( 
`Id` int(11) NOT NULL AUTO_INCREMENT, 
`Name` TEXT  NOT NULL,
`Code` TEXT  NOT NULL,
`TitleEstimation` TEXT  NOT NULL,
`MetaEstimationDescription` TEXT  NOT NULL,
`DescriptionEstimation` TEXT  NOT NULL,
`TitleImmobilier` TEXT  NOT NULL,
`MetaImmobilierDescription` TEXT  NOT NULL,
`DescriptionImmobilier` TEXT  NOT NULL,
`NoResultDescription` TEXT  NOT NULL,
`RecentSale` TEXT  NOT NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB  DEFAULT CHARACTER SET `utf8`; 