--
-- Structure de la table `marqueurs`
--

CREATE TABLE IF NOT EXISTS `marqueurs` (
  `id` int(11) NOT NULL auto_increment,
  `nom` varchar(100) collate utf8_unicode_ci NOT NULL,
  `adresse` varchar(150) collate utf8_unicode_ci NOT NULL,
  `codepostal` float(5,0) NOT NULL,
  `ville` varchar(255) collate utf8_unicode_ci NOT NULL,
  `lat` float(10,6) NOT NULL,
  `lng` float(10,6) NOT NULL,
  `url` varchar(255) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;