Subversion Repositories eFlore/Projets.eflore-projets

-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Généré le : Mer 15 Juin 2011 à 16:30
-- Version du serveur: 5.5.8
-- Version de PHP: 5.3.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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 utf8 */;

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

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

--
-- Structure de la table `osm_communes`
--

CREATE TABLE IF NOT EXISTS `osm_communes` (
  `id_relation` int(11) NOT NULL,
  `nom` text NOT NULL,
  `code_insee` varchar(11) NOT NULL,
  `polygon` multipolygon DEFAULT NULL,
  `note` varchar(100) NOT NULL,
  `centre` point NOT NULL,
  PRIMARY KEY (`id_relation`),
  KEY `INSEE` (`code_insee`),
  KEY `communeOSM_polygone_index` (`polygon`(767),`centre`(25))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Structure de la table `osm_chemin_a_noeuds`
--

CREATE TABLE IF NOT EXISTS `osm_chemin_a_noeuds` (
  `id_chemin` int(11) NOT NULL,
  `id_noeud` int(11) NOT NULL,
  `ordre` int(11) NOT NULL,
  PRIMARY KEY (`id_chemin`,`id_noeud`,`ordre`),
  KEY `id_way` (`id_chemin`),
  KEY `id_node` (`id_noeud`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

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

--
-- Structure de la table `osm_noeuds`
--

CREATE TABLE IF NOT EXISTS `osm_noeuds` (
  `id_noeud` int(11) NOT NULL,
  `lat` double NOT NULL,
  `long` double NOT NULL,
  PRIMARY KEY (`id_noeud`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Structure de la table `osm_relations`
--

CREATE TABLE IF NOT EXISTS `osm_relations` (
  `id_relation` int(11) NOT NULL,
  `nom` text NOT NULL,
  `code_insee` varchar(11) NOT NULL,
  PRIMARY KEY (`id_relation`),
  KEY `INSEE` (`code_insee`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Structure de la table `osm_relation_a_chemins`
--

CREATE TABLE IF NOT EXISTS `osm_relation_a_chemins` (
  `id_relation` int(11) NOT NULL,
  `id_chemin` int(11) NOT NULL,
  `role` varchar(20) CHARACTER SET latin1 NOT NULL,
  `ordre` int(11) NOT NULL,
  `sens` varchar(15) CHARACTER SET latin1 NOT NULL,
  `nbre_poly` int(11) NOT NULL,
  PRIMARY KEY (`id_relation`,`id_chemin`),
  KEY `role` (`role`),
  KEY `ordre` (`ordre`),
  KEY `sens` (`sens`),
  KEY `nbPoly` (`nbre_poly`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;