| New file |
|---|
| 0,0 → 1,93 |
|---|
| SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; |
| SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; |
| SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES'; |
| |
| CREATE SCHEMA IF NOT EXISTS `tb_eflore` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ; |
| USE `tb_eflore` ; |
| |
| -- ----------------------------------------------------- |
| -- Table `tb_eflore`.`osm_noeuds` |
| -- ----------------------------------------------------- |
| DROP TABLE IF EXISTS `tb_eflore`.`osm_noeuds` ; |
| |
| CREATE TABLE IF NOT EXISTS `tb_eflore`.`osm_noeuds` ( |
| `id_noeud` BIGINT NOT NULL , |
| `lat` DOUBLE NOT NULL , |
| `long` DOUBLE NOT NULL , |
| PRIMARY KEY (`id_noeud`) ) |
| ENGINE = InnoDB; |
| |
| |
| -- ----------------------------------------------------- |
| -- Table `tb_eflore`.`osm_chemin_a_noeuds` |
| -- ----------------------------------------------------- |
| DROP TABLE IF EXISTS `tb_eflore`.`osm_chemin_a_noeuds` ; |
| |
| CREATE TABLE IF NOT EXISTS `tb_eflore`.`osm_chemin_a_noeuds` ( |
| `id_chemin` BIGINT NOT NULL , |
| `id_noeud` BIGINT NOT NULL , |
| `ordre` INT NOT NULL , |
| PRIMARY KEY (`id_chemin`, `id_noeud`, `ordre`) , |
| INDEX `id_noeud` (`id_noeud` ASC) , |
| INDEX `id_chemin` (`id_chemin` ASC) , |
| CONSTRAINT `avoir_noeud` |
| FOREIGN KEY (`id_noeud` ) |
| REFERENCES `tb_eflore`.`osm_noeuds` (`id_noeud` ) |
| ON DELETE NO ACTION |
| ON UPDATE NO ACTION) |
| ENGINE = InnoDB; |
| |
| |
| -- ----------------------------------------------------- |
| -- Table `tb_eflore`.`osm_commune` |
| -- ----------------------------------------------------- |
| DROP TABLE IF EXISTS `tb_eflore`.`osm_commune` ; |
| |
| CREATE TABLE IF NOT EXISTS `tb_eflore`.`osm_commune` ( |
| `id_relation` BIGINT NOT NULL , |
| `nom` VARCHAR(255) NULL , |
| `code_insee` VARCHAR(5) NULL , |
| `polygone` MULTIPOLYGON NULL , |
| `centre` POINT NULL , |
| `notes` TEXT NULL , |
| PRIMARY KEY (`id_relation`) , |
| INDEX `code_insee` (`code_insee` ASC) , |
| INDEX `commune_polygone` USING BTREE (`polygone` ASC, `centre` ASC) ) |
| ENGINE = InnoDB; |
| |
| |
| -- ----------------------------------------------------- |
| -- Table `tb_eflore`.`osm_relation_a_chemins` |
| -- ----------------------------------------------------- |
| DROP TABLE IF EXISTS `tb_eflore`.`osm_relation_a_chemins` ; |
| |
| CREATE TABLE IF NOT EXISTS `tb_eflore`.`osm_relation_a_chemins` ( |
| `id_relation` BIGINT NOT NULL , |
| `id_chemin` BIGINT NOT NULL , |
| `role` VARCHAR(20) NOT NULL , |
| `ordre` INT NOT NULL , |
| `sens` VARCHAR(15) NOT NULL , |
| `nbre_poly` INT NOT NULL , |
| PRIMARY KEY (`id_relation`, `id_chemin`) , |
| INDEX `role` (`role` ASC) , |
| INDEX `sens` (`sens` ASC) , |
| INDEX `ordre` (`ordre` ASC) , |
| INDEX `nbre_poly` (`nbre_poly` ASC) , |
| CONSTRAINT `avoir_chemin_a_noeuds` |
| FOREIGN KEY () |
| REFERENCES `tb_eflore`.`osm_chemin_a_noeuds` () |
| ON DELETE NO ACTION |
| ON UPDATE NO ACTION, |
| CONSTRAINT `avoir_commune` |
| FOREIGN KEY () |
| REFERENCES `tb_eflore`.`osm_commune` () |
| ON DELETE NO ACTION |
| ON UPDATE NO ACTION) |
| ENGINE = InnoDB; |
| |
| USE `tb_eflore` ; |
| |
| |
| SET SQL_MODE=@OLD_SQL_MODE; |
| SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; |
| SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS; |