Subversion Repositories eFlore/Projets.eflore-projets

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
166 jpm 1
-- phpMyAdmin SQL Dump
2
-- version 3.3.9
3
-- http://www.phpmyadmin.net
4
--
5
-- Serveur: localhost
6
-- Généré le : Mer 15 Juin 2011 à 16:30
7
-- Version du serveur: 5.5.8
8
-- Version de PHP: 5.3.5
9
 
10
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11
 
12
 
13
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
14
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
15
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
16
/*!40101 SET NAMES utf8 */;
17
 
18
--
19
-- Base de données: `osmMAJ`
20
--
21
 
22
-- --------------------------------------------------------
23
 
24
--
25
-- Structure de la table `osm_communes`
26
--
27
 
28
CREATE TABLE IF NOT EXISTS `osm_communes` (
29
  `id_relation` int(11) NOT NULL,
30
  `nom` text NOT NULL,
31
  `code_insee` varchar(11) NOT NULL,
32
  `polygon` multipolygon DEFAULT NULL,
33
  `note` varchar(100) NOT NULL,
34
  `centre` point NOT NULL,
35
  PRIMARY KEY (`id_relation`),
36
  KEY `INSEE` (`code_insee`),
37
  KEY `communeOSM_polygone_index` (`polygon`(767),`centre`(25))
38
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
39
 
40
-- --------------------------------------------------------
41
 
42
--
43
-- Structure de la table `osm_chemin_a_noeuds`
44
--
45
 
46
CREATE TABLE IF NOT EXISTS `osm_chemin_a_noeuds` (
47
  `id_chemin` int(11) NOT NULL,
48
  `id_noeud` int(11) NOT NULL,
49
  `ordre` int(11) NOT NULL,
50
  PRIMARY KEY (`id_chemin`,`id_noeud`,`ordre`),
51
  KEY `id_way` (`id_chemin`),
52
  KEY `id_node` (`id_noeud`)
53
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
54
 
55
-- --------------------------------------------------------
56
 
57
--
58
-- Structure de la table `osm_noeuds`
59
--
60
 
61
CREATE TABLE IF NOT EXISTS `osm_noeuds` (
62
  `id_noeud` int(11) NOT NULL,
63
  `lat` double NOT NULL,
64
  `long` double NOT NULL,
65
  PRIMARY KEY (`id_noeud`)
66
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
67
 
68
-- --------------------------------------------------------
69
 
70
--
71
-- Structure de la table `osm_relations`
72
--
73
 
74
CREATE TABLE IF NOT EXISTS `osm_relations` (
75
  `id_relation` int(11) NOT NULL,
76
  `nom` text NOT NULL,
77
  `code_insee` varchar(11) NOT NULL,
78
  PRIMARY KEY (`id_relation`),
79
  KEY `INSEE` (`code_insee`)
80
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
81
 
82
-- --------------------------------------------------------
83
 
84
--
85
-- Structure de la table `osm_relation_a_chemins`
86
--
87
 
88
CREATE TABLE IF NOT EXISTS `osm_relation_a_chemins` (
89
  `id_relation` int(11) NOT NULL,
90
  `id_chemin` int(11) NOT NULL,
91
  `role` varchar(20) CHARACTER SET latin1 NOT NULL,
92
  `ordre` int(11) NOT NULL,
93
  `sens` varchar(15) CHARACTER SET latin1 NOT NULL,
94
  `nbre_poly` int(11) NOT NULL,
95
  PRIMARY KEY (`id_relation`,`id_chemin`),
96
  KEY `role` (`role`),
97
  KEY `ordre` (`ordre`),
98
  KEY `sens` (`sens`),
99
  KEY `nbPoly` (`nbre_poly`)
100
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
101