--
-- Structure de la table `resto`
--

CREATE TABLE IF NOT EXISTS `resto` (
  `id` bigint(255) NOT NULL,
  `id_categ` mediumint(100) UNSIGNED DEFAULT '0',
  `date` datetime NOT NULL,
  `hits` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `note` decimal(5,2) NOT NULL DEFAULT '0.00',
  `rapport_qp` tinyint(4) NOT NULL,
  `title` varchar(40) NOT NULL,
  `address` mediumtext NOT NULL,
  `cap` varchar(15) DEFAULT NULL,
  `city` varchar(50) NOT NULL,
  `latitude` varchar(25) NOT NULL,
  `longitude` varchar(25) NOT NULL,
  `phone` varchar(15) DEFAULT NULL,
  `mobile_resa` tinyint(10) NOT NULL,
  `email_resa` varchar(60) DEFAULT NULL,
  `chef` tinytext NOT NULL,
  `chefAge` tinytext NOT NULL,
  `chefSpecialites` tinytext NOT NULL,
  `chefParcours` tinytext NOT NULL,
  `chefEtoile` tinytext NOT NULL,
  `horferm` mediumtext NOT NULL,
  `video` mediumtext NOT NULL,
  `website` mediumtext NOT NULL,
  `description` text NOT NULL,
  `motscles` text NOT NULL,
  `counter_reset` mediumint(9) UNSIGNED NOT NULL DEFAULT '0',
  `url_video` varchar(255) NOT NULL,
  `youtube_link` varchar(255) NOT NULL,
  `menu_entree` text NOT NULL,
  `menu_plat` text NOT NULL,
  `menu_dessert` text NOT NULL,
  `client` int(10) NOT NULL,
  `resa` enum('n','y') NOT NULL DEFAULT 'n',
  `nombre_maxi_dejeuner` tinyint(3) UNSIGNED NOT NULL,
  `nombre_maxi_diner` tinyint(3) UNSIGNED NOT NULL,
  `aime` mediumtext NOT NULL,
  `article` mediumtext NOT NULL,
  `ofinal` mediumtext NOT NULL,
  `qualite_service` tinytext NOT NULL,
  `pain` tinytext NOT NULL,
  `serviette` mediumtext NOT NULL,
  `latable` mediumtext NOT NULL,
  `promoclub` enum('n','y') NOT NULL DEFAULT 'n',
  `interfacepromo` text NOT NULL,
  `formule_un` tinytext NOT NULL,
  `formule_deux` tinytext NOT NULL,
  `formule_trois` tinytext NOT NULL,
  `prix_entree` tinyint(4) DEFAULT NULL,
  `prix_plat` tinyint(4) DEFAULT NULL,
  `prix_dessert` varchar(100) DEFAULT NULL,
  `prix_formule_un` varchar(4) DEFAULT NULL,
  `prix_formule_deux` varchar(4) DEFAULT NULL,
  `prix_formule_trois` varchar(4) DEFAULT NULL,
  `menu_entree_deux` tinytext NOT NULL,
  `menu_plat_deux` tinytext NOT NULL,
  `prix_entree_deux` tinyint(4) DEFAULT NULL,
  `prix_plat_deux` tinyint(4) DEFAULT NULL,
  `titre_offre` tinytext NOT NULL,
  `description_offre` mediumtext NOT NULL,
  `date_offre` tinytext NOT NULL,
  `date_expiration_offre` tinytext NOT NULL,
  `pourcent` tinyint(4) NOT NULL,
  `jours` tinytext NOT NULL,
  `offre_sapplique` tinytext NOT NULL,
  `midi_entree_moins_cher` varchar(100) NOT NULL,
  `lunch_starter_low_price` decimal(5,2) DEFAULT NULL,
  `midi_entree_plus_cher` varchar(100) NOT NULL,
  `lunch_starter_high_price` decimal(5,2) DEFAULT NULL,
  `midi_entree_prix_moyen` varchar(50) DEFAULT NULL,
  `midi_plat_moins_cher` varchar(100) NOT NULL,
  `lunch_main_low_price` decimal(5,2) DEFAULT NULL,
  `midi_plat_plus_cher` varchar(100) NOT NULL,
  `lunch_main_high_price` decimal(5,2) DEFAULT NULL,
  `midi_plat_prix_moyen` varchar(50) DEFAULT NULL,
  `soir_entree_moins_cher` varchar(50) NOT NULL,
  `soir_plat_moins_cher` varchar(50) NOT NULL,
  `soir_entree_plus_cher` varchar(50) NOT NULL,
  `soir_plat_plus_cher` varchar(50) NOT NULL,
  `soir_prix_moyen` varchar(50) DEFAULT NULL,
  `vin_moins_cher` varchar(100) NOT NULL,
  `vin_plus_cher` varchar(100) NOT NULL,
  `vin_prix_moyen` varchar(50) NOT NULL,
  `specialites` mediumtext NOT NULL,
  `specialites2` mediumtext NOT NULL,
  `guest1` varchar(100) NOT NULL,
  `guest2` varchar(100) NOT NULL,
  `point_interet` mediumtext NOT NULL,
  `100Maison` enum('n','y') NOT NULL DEFAULT 'n',
  `michelin` enum('n','y') NOT NULL DEFAULT 'n',
  `poisson` enum('n','y') NOT NULL DEFAULT 'n',
  `poisson_local` enum('n','y') NOT NULL DEFAULT 'n',
  `viande` enum('n','y') NOT NULL DEFAULT 'n',
  `dessert_maison` enum('n','y') NOT NULL DEFAULT 'n',
  `maitre_restaurateur` enum('n','y') NOT NULL DEFAULT 'n',
  `burger` enum('n','y') NOT NULL DEFAULT 'n',
  `produits_locaux` enum('n','y') NOT NULL DEFAULT 'n',
  `bistro` enum('n','y') NOT NULL DEFAULT 'n',
  `sans_gluten` enum('n','y') NOT NULL DEFAULT 'n',
  `bio` enum('n','y') NOT NULL DEFAULT 'n',
  `recommande` tinytext NOT NULL,
  `vu` tinytext NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id_categ` (`id_categ`),
  KEY `title` (`title`),
  KEY `city` (`city`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `resto`
--

INSERT INTO `resto` (`id`, `id_categ`, `date`, `hits`, `note`, `rapport_qp`, `title`, `address`, `cap`, `city`, `latitude`, `longitude`, `phone`, `mobile_resa`, `email_resa`, `chef`, `chefAge`, `chefSpecialites`, `chefParcours`, `chefEtoile`, `horferm`, `video`, `website`, `description`, `motscles`, `counter_reset`, `url_video`, `youtube_link`, `menu_entree`, `menu_plat`, `menu_dessert`, `client`, `resa`, `nombre_maxi_dejeuner`, `nombre_maxi_diner`, `aime`, `article`, `ofinal`, `qualite_service`, `pain`, `serviette`, `latable`, `promoclub`, `interfacepromo`, `formule_un`, `formule_deux`, `formule_trois`, `prix_entree`, `prix_plat`, `prix_dessert`, `prix_formule_un`, `prix_formule_deux`, `prix_formule_trois`, `menu_entree_deux`, `menu_plat_deux`, `prix_entree_deux`, `prix_plat_deux`, `titre_offre`, `description_offre`, `date_offre`, `date_expiration_offre`, `pourcent`, `jours`, `offre_sapplique`, `midi_entree_moins_cher`, `lunch_starter_low_price`, `midi_entree_plus_cher`, `lunch_starter_high_price`, `midi_entree_prix_moyen`, `midi_plat_moins_cher`, `lunch_main_low_price`, `midi_plat_plus_cher`, `lunch_main_high_price`, `midi_plat_prix_moyen`, `soir_entree_moins_cher`, `soir_plat_moins_cher`, `soir_entree_plus_cher`, `soir_plat_plus_cher`, `soir_prix_moyen`, `vin_moins_cher`, `vin_plus_cher`, `vin_prix_moyen`, `specialites`, `specialites2`, `guest1`, `guest2`, `point_interet`, `100Maison`, `michelin`, `poisson`, `poisson_local`, `viande`, `dessert_maison`, `maitre_restaurateur`, `burger`, `produits_locaux`, `bistro`, `sans_gluten`, `bio`, `recommande`, `vu`) VALUES