--
-- Table structure for table `raw`
--

CREATE TABLE IF NOT EXISTS `raw` (
  `id` int(11) NOT NULL auto_increment,
  `res_id` int(11) default NULL,
  `vendor` enum('chequegourmet','mobiticket','sodexo') NOT NULL,
  `name` varchar(128) NOT NULL,
  `address` varchar(128) NOT NULL,
  `town` varchar(64) NOT NULL,
  `province` varchar(64) default NULL,
  `cp` varchar(10) NOT NULL,
  `phone` varchar(24) NOT NULL,
  `food` varchar(64) default NULL,
  `latitude` float default NULL,
  `longitude` float default NULL,
  `GGeoJSONResponse` text NOT NULL,
  `GGeoCountPlacemarks` smallint(5) unsigned NOT NULL,
  `GGeoStatusCode` smallint(5) unsigned NOT NULL,
  `GGeoAddressAccuracy` smallint(5) unsigned NOT NULL,
  `GGeoAddress` varchar(255) NOT NULL,
  `GGeoAdministrativeAreaName` varchar(64) NOT NULL,
  `GGeoLocalityName` varchar(64) NOT NULL,
  `GGeoPostalCodeNumber` varchar(64) NOT NULL,
  `GGeoThoroughfareName` varchar(255) NOT NULL,
  `GGeoSubAdministrativeAreaName` varchar(64) NOT NULL,
  `GGeoCountryName` varchar(64) NOT NULL,
  `GGeoCountryNameCode` varchar(10) NOT NULL,
  `GGeoLatitude` float NOT NULL,
  `GGeoLongitude` float NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `food` (`food`),
  KEY `res_id` (`res_id`),
  KEY `vendor` (`vendor`),
  KEY `name` (`name`),
  KEY `town` (`town`),
  KEY `cp` (`cp`),
  KEY `latitude` (`latitude`),
  KEY `longitude` (`longitude`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;