New file |
0,0 → 1,101 |
-- 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; |
|