-- phpMyAdmin SQL Dump
-- version 4.6.6
-- https://www.phpmyadmin.net/
--
-- Client :  localhost:3306
-- Généré le :  Dim 17 Décembre 2017 à 15:18
-- Version du serveur :  10.0.32-MariaDB-0+deb8u1
-- Version de PHP :  5.6.27

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Base de données :  `lc3075_cws`
--

-- --------------------------------------------------------

--
-- Structure de la table `society_coords`
--

CREATE TABLE `society_coords` (
  `geolocation_subid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `society` varchar(250) NOT NULL DEFAULT '',
  `country` varchar(255) NOT NULL DEFAULT '',
  `speciality` varchar(250) NOT NULL DEFAULT '',
  `coordinates` varchar(27) CHARACTER SET utf8mb4 NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Contenu de la table `society_coords`
--

INSERT INTO `society_coords` (`geolocation_subid`, `society`, `country`, `speciality`, `coordinates`) VALUES
(23709, '', 'France', 'OTHER', '(48.853400,2.348800):2'),
(35634, 'LEOPOLD BRUSSELS HOTEL EU', 'Belgium', 'HOTEL', '(50.850400,4.348780):2'),
(53464, 'LA CLOSERIE', 'France', 'RESTAURANT', '(47.522600,6.662220):2'),
(61790, 'LE CHARLEMAGNE', 'Belgium', 'RESTAURANT', '(50.003500,5.718440):2'),
(73117, 'HELeNE DARROZE', 'France', 'RESTAURANT', '(47.466700,-0.550000):2'),
(73815, 'RESTAURANT DAVID TOUTAIN', 'France', 'RESTAURANT', '(49.243900,1.832800):2'),
(174908, 'BULION TRAITEUR', 'France', 'TRAITEUR', '(48.939700,7.185560):2'),
(211343, '', 'France', 'CHEF', '(43.703100,7.266080):2'),
(211365, '', 'United States', 'OTHER GASTRONOMY SPECIALTY', '(37.406000,-122.079000):2'),
(212428, '', 'France', 'OTHER FOOD INDUSTRY', '(43.703100,7.266080):2'),
(229444, 'KEISUKE MATSUSHIMA', 'United States', 'HEAD CHEF', '(37.406000,-122.079000):2'),
(231084, 'BISTROT DU PORT', 'France', 'MANAGEMENT', '(43.703100,7.266080):2'),
(231143, '', 'France', 'OTHER GASTRONOMY SPECIALTY', '(43.703100,7.266080):2'),
(237586, 'MANUFACTURE DE MONACO', 'Monaco', 'OTHER', '(43.733300,7.416670):2'),
(247329, '', 'United States', 'CHEF', '(37.401200,-122.008000):2'),
(253759, '', 'France', 'OTHER GASTRONOMY SPECIALTY', '(42.697600,2.895410):2'),
(253773, '', 'Mauritius', 'CHEF DE CUISINE', '(-20.314700,57.520300):2'),
(256910, '', 'France', 'ENGINEER', '(49.738300,3.257360):2'),
(259206, '', 'United States', 'CHEF DE CUISINE', '(37.406000,-122.079000):2'),
(264552, '', 'France', 'CHEF', '(43.116700,5.933330):2'),
(267819, 'FROMENT ET SARRASIN', 'France', 'COMMIS', '(50.694200,3.174560):2'),
(278430, 'BELLES RIVES LA PASSAGERE', 'France', 'STARRED RESTAURANT', '(43.632800,1.393990):2'),
(278485, 'MUSEE ESCOFFIER DE L ART CULINAIRE', 'United States', 'DIRECTEUR D ETABLISSMENT', '(37.401200,-122.008000):2'),
(278575, 'HOTEL RITZ PARIS', 'France', 'SOUS CHEF', '(48.112000,-1.674290):2'),
(279345, '', 'France', 'OTHER GASTRONOMY SPECIALTY', '(50.694200,3.174560):2'),
(279399, 'STAFF PERSONNEL EVENEMENTIEL INC', 'United States', 'OTHER GASTRONOMY SPECIALTY', '(37.401200,-122.008000):2'),
(280045, 'LE COEUR DES CHEFS', 'France', 'OTHER GASTRONOMY SPECIALTY', '(48.821000,2.277180):2'),
(280206, 'CHARCUTERIE D AUVERGNE', 'France', 'CHEF DE PRODUIT', '(45.748500,4.846710):2'),
(280299, '', 'France', 'PRESS', '(43.703100,7.266080):2'),
(280398, 'PAIN - PETIFOUR MIDIPAIN', 'France', 'OTHER GASTRONOMY SPECIALTY', '(45.900000,6.100000):2'),
(281602, 'RISTORANTE BISTROT DELLA BOTTEGA DEL GUSTO', 'Italy', 'CHEF DE PRODUIT', '(45.070500,7.686820):2'),
(281721, 'MUSEE ESCOFFIER DE L ART CULINAIRE', 'France', 'DIRECTEUR D ETABLISSMENT', '(43.703100,7.266080):2'),
(282004, 'MEILLEURS OUVRIERS DE FRANCE', 'France', 'OTHER GASTRONOMY SPECIALTY', '(43.703100,7.266080):2'),
(283869, 'LA TERRASSE DU PL', 'France', 'INDEPENDANT HOTEL', '(50.533300,2.633330):2'),
(285627, 'BEVANAR SA', 'Monaco', 'DISTRIBUTOR', '(43.733300,7.416670):2');

--
-- Index pour les tables exportées
--

--
-- Index pour la table `society_coords`
--
ALTER TABLE `society_coords`
  ADD PRIMARY KEY (`geolocation_subid`);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
