Subversion Repositories eFlore/Projets.eflore-projets

Rev

Rev 227 | Only display areas with differences | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 227 Rev 235
- 
 
 1 
--
- 
 
 2 
-- Structure de la table `prometheus_meta`
- 
 
 3 
--
- 
 
 4 
 
- 
 
 5 
CREATE TABLE IF NOT EXISTS `prometheus_meta` (
- 
 
 6 
  `guid` varchar(255) NOT NULL DEFAULT 'urn:lsid:tela-botanica.org:#projet:#version',
- 
 
 7 
  `langue_meta` varchar(2) NOT NULL DEFAULT 'fr',
- 
 
 8 
  `code` varchar(20) NOT NULL,
- 
 
 9 
  `version` varchar(20) NOT NULL,
- 
 
 10 
  `titre` varchar(255) DEFAULT NULL,
- 
 
 11 
  `description` text,
- 
 
 12 
  `mots_cles` varchar(510) DEFAULT NULL,
- 
 
 13 
  `citation` varchar(255) DEFAULT NULL,
- 
 
 14 
  `url_tech` varchar(510) DEFAULT NULL,
- 
 
 15 
  `url_projet` varchar(510) DEFAULT NULL,
- 
 
 16 
  `source` text,
- 
 
 17 
  `createurs` text,
- 
 
 18 
  `editeur` varchar(1000) NOT NULL DEFAULT 'nom=Tela Botanica;guid=urn:lsid:tela-botanica.org;courriel=accueil@tela-botanica.org;telephone=+334 67 52 41 22;url.info=http://www.tela-botanica.org/page:association_tela_botanica;url.logo=http://www.tela-botanica.org/sites/accueil/generique/images/graphisme/logo_tela_fond_blanc.png;type=organisation;acronyme=TB;adresse=Association Tela Botanica - Institut de Botanique - 167 rue Auguste Broussonnet 34090 MONTPELLIER, FRANCE;latitude.wgs84=43.615892;longitude.wgs84=3.871736;contact.prenom=Jean-Pascal;contact.nom=MILCENT;contact.courriel=jpm@tela-botanica.org;contact.role=administrateur des données;',
- 
 
 19 
  `contributeurs` text,
- 
 
 20 
  `droits` text,
- 
 
 21 
  `url_droits` varchar(510) DEFAULT NULL,
- 
 
 22 
  `langue` varchar(255) NOT NULL DEFAULT 'fr',
- 
 
 23 
  `date_creation` varchar(30) NOT NULL DEFAULT 'YYYY-MM-DD',
- 
 
 24 
  `date_validite` varchar(255) DEFAULT NULL,
- 
 
 25 
  `couverture_spatiale` varchar(510) NOT NULL DEFAULT 'iso-3166-1.id=FX;',
- 
 
 26 
  `couverture_temporelle` varchar(510) DEFAULT NULL,
- 
 
 27 
  `web_services` varchar(510) DEFAULT NULL COMMENT 'ontologies,meta-donnees,noms,taxons,aide,textes,images,observations,noms-vernaculaires',
- 
 
 28 
  PRIMARY KEY (`guid`,`langue_meta`)
- 
 
 29 
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- 
 
 30 
 
- 
 
 31 
--
- 
 
 32 
-- Contenu de la table `prometheus_meta`
- 
 
 33 
--
- 
 
 34 
 
- 
 
 35 
INSERT INTO `prometheus_meta` (`guid`, `langue_meta`, `code`, `version`, `titre`, `description`, `mots_cles`, `citation`, `url_tech`, `url_projet`, `source`, `createurs`, `editeur`, `contributeurs`, `droits`, `url_droits`, `langue`, `date_creation`, `date_validite`, `couverture_spatiale`, `couverture_temporelle`, `web_services`) VALUES
- 
 
 36 
('urn:lsid:tela-botanica.org:prometheus:1.00', 'fr', 'PROMETHEUS', '1.00', 'Ontologie de la botanique réalisée dans le cadre du projet Prometheus.', 'Ontologie de la botanique réalisée dans le cadre du projet Prometheus.\r\nTraduction des termes en français par le réseau Tela Botanica.\r\n', 'ontologie, botanique.', NULL, 'http://www.tela-botanica.org/wikini/eflore/wakka.php?wiki=IntegrationPrometheus', 'http://www.jstor.org/stable/25065431', 'http://www.jstor.org/stable/25065431', 'Armstrong, Kate\r\np.prenom=Kate,p.nom=Armstrong,p.courriel=k.armstrong@rbge.org,o.nom=Royal Botanic Garden', '', NULL, 'Copyright © tela-botanica.org (2012). Tout droits réservés.', NULL, 'en,fr', '2003-02-18', NULL, '', NULL, 'metaDonnees:0.2;ontologies:0.2');
- 
 
 37 
 
1 
-- -----------------------------------------------------
 38 
-- -----------------------------------------------------
2 
-- Table `ontologie_type`
 39 
-- Table `prometheus_ontologies_type`
3 
-- -----------------------------------------------------
 40 
-- -----------------------------------------------------
4 
CREATE  TABLE IF NOT EXISTS `ontologie_type` (
 41 
CREATE  TABLE IF NOT EXISTS `prometheus_ontologies_type` (
5 
  `id_type` INT NOT NULL ,
 42 
  `id_type` INT NOT NULL ,
6 
  `id_type_parent` INT NOT NULL DEFAULT 0 ,
 43 
  `id_type_parent` INT NOT NULL DEFAULT 0 ,
7 
  `type` VARCHAR(45) NULL ,
 44 
  `type` VARCHAR(45) NULL ,
8 
  `description` TEXT NULL ,
 45 
  `description` TEXT NULL ,
9 
  PRIMARY KEY (`id_type`) )
 46 
  PRIMARY KEY (`id_type`) )
10 
ENGINE = MyISAM
 47 
ENGINE = MyISAM
11 
DEFAULT CHARACTER SET = utf8
 48 
DEFAULT CHARACTER SET = utf8
12 
COLLATE = utf8_general_ci;
 49 
COLLATE = utf8_general_ci;
13 
 
 50 
 
14 
 
 51 
 
15 
-- -----------------------------------------------------
 52 
-- -----------------------------------------------------
16 
-- Table `ontologie_auteur`
 53 
-- Table `prometheus_ontologies_auteur`
17 
-- -----------------------------------------------------
 54 
-- -----------------------------------------------------
18 
CREATE  TABLE IF NOT EXISTS `ontologie_auteur` (
 55 
CREATE  TABLE IF NOT EXISTS `prometheus_ontologies_auteur` (
19 
  `id_auteur` INT NOT NULL ,
 56 
  `id_auteur` INT NOT NULL ,
20 
  `prenom` VARCHAR(45) NULL ,
 57 
  `prenom` VARCHAR(45) NULL ,
21 
  `nom` VARCHAR(45) NULL ,
 58 
  `nom` VARCHAR(45) NULL ,
22 
  `pseudo` VARCHAR(90) NULL ,
 59 
  `pseudo` VARCHAR(90) NULL ,
23 
  `naissance_date` DATE NULL ,
 60 
  `naissance_date` DATE NULL ,
24 
  `deces_date` DATE NULL ,
 61 
  `deces_date` DATE NULL ,
25 
  PRIMARY KEY (`id_auteur`) )
 62 
  PRIMARY KEY (`id_auteur`) )
26 
ENGINE = MyISAM
 63 
ENGINE = MyISAM
27 
DEFAULT CHARACTER SET = utf8
 64 
DEFAULT CHARACTER SET = utf8
28 
COLLATE = utf8_general_ci;
 65 
COLLATE = utf8_general_ci;
29 
 
 66 
 
30 
 
 67 
 
31 
-- -----------------------------------------------------
 68 
-- -----------------------------------------------------
32 
-- Table `ontologie_publication`
 69 
-- Table `prometheus_ontologies_publication`
33 
-- -----------------------------------------------------
 70 
-- -----------------------------------------------------
34 
CREATE  TABLE IF NOT EXISTS `ontologie_publication` (
 71 
CREATE  TABLE IF NOT EXISTS `prometheus_ontologies_publication` (
35 
  `id_publication` INT NOT NULL ,
 72 
  `id_publication` INT NOT NULL ,
36 
  `ce_auteur_principal` INT NOT NULL ,
 73 
  `ce_auteur_principal` INT NOT NULL ,
37 
  `titre` VARCHAR(255) NULL ,
 74 
  `titre` VARCHAR(255) NULL ,
38 
  `date` DATE NULL ,
 75 
  `date` DATE NULL ,
39 
  `uri` VARCHAR(255) NULL ,
 76 
  `uri` VARCHAR(255) NULL ,
40 
  PRIMARY KEY (`id_publication`) ,
 77 
  PRIMARY KEY (`id_publication`) ,
41 
  INDEX `fk_ontologie_publication_ontologie_auteur1` (`ce_auteur_principal` ASC) ,
 78 
  INDEX `fk_ontologie_publication_ontologie_auteur1` (`ce_auteur_principal` ASC) )
42 
  CONSTRAINT `fk_ontologie_publication_ontologie_auteur1`
 - 
 
43 
    FOREIGN KEY (`ce_auteur_principal` )
 - 
 
44 
    REFERENCES `ontologie_auteur` (`id_auteur` )
 - 
 
45 
    ON DELETE NO ACTION
 - 
 
46 
    ON UPDATE NO ACTION)
 - 
 
47 
ENGINE = MyISAM
 79 
ENGINE = MyISAM
48 
DEFAULT CHARACTER SET = utf8
 80 
DEFAULT CHARACTER SET = utf8
49 
COLLATE = utf8_general_ci;
 81 
COLLATE = utf8_general_ci;
50 
 
 82 
 
51 
 
 83 
 
52 
-- -----------------------------------------------------
 84 
-- -----------------------------------------------------
53 
-- Table `ontologie_image`
 85 
-- Table `prometheus_ontologies_image`
54 
-- -----------------------------------------------------
 86 
-- -----------------------------------------------------
55 
CREATE  TABLE IF NOT EXISTS `ontologie_image` (
 87 
CREATE  TABLE IF NOT EXISTS `prometheus_ontologies_image` (
56 
  `id_image` INT NOT NULL ,
 88 
  `id_image` INT NOT NULL ,
57 
  `uri` VARCHAR(255) NULL ,
 89 
  `uri` VARCHAR(255) NULL ,
58 
  `ce_publication` INT NOT NULL ,
 90 
  `ce_publication` INT NOT NULL ,
59 
  PRIMARY KEY (`id_image`) ,
 91 
  PRIMARY KEY (`id_image`) ,
60 
  INDEX `fk_ontologie_image_ontologie_publication1` (`ce_publication` ASC) ,
 92 
  INDEX `fk_ontologie_image_ontologie_publication1` (`ce_publication` ASC) )
61 
  CONSTRAINT `fk_ontologie_image_ontologie_publication1`
 - 
 
62 
    FOREIGN KEY (`ce_publication` )
 - 
 
63 
    REFERENCES `ontologie_publication` (`id_publication` )
 - 
 
64 
    ON DELETE NO ACTION
 - 
 
65 
    ON UPDATE NO ACTION)
 - 
 
66 
ENGINE = MyISAM
 93 
ENGINE = MyISAM
67 
DEFAULT CHARACTER SET = utf8
 94 
DEFAULT CHARACTER SET = utf8
68 
COLLATE = utf8_general_ci;
 95 
COLLATE = utf8_general_ci;
69 
 
 96 
 
70 
 
 97 
 
71 
-- -----------------------------------------------------
 98 
-- -----------------------------------------------------
72 
-- Table `ontologie_terme`
 99 
-- Table `prometheus_ontologies_terme`
73 
-- -----------------------------------------------------
 100 
-- -----------------------------------------------------
74 
CREATE  TABLE IF NOT EXISTS `ontologie_terme` (
 101 
CREATE  TABLE IF NOT EXISTS `prometheus_ontologies_terme` (
75 
  `id_terme` INT NOT NULL COMMENT 'Identifiant global du terme (GLOBALID)' ,
 102 
  `id_terme` INT NOT NULL COMMENT 'Identifiant global du terme (GLOBALID)' ,
76 
  `ce_type` INT NOT NULL ,
 103 
  `ce_type` INT NOT NULL ,
77 
  `terme` VARCHAR(255) NOT NULL ,
 104 
  `nom` VARCHAR(255) NOT NULL ,
78 
  `definition` TEXT NULL ,
 105 
  `description` TEXT NULL ,
79 
  `terme_fr` VARCHAR(255) NULL ,
 106 
  `nom_en` VARCHAR(255) NULL ,
80 
  `definition_fr` TEXT NULL ,
 107 
  `description_en` TEXT NULL ,
81 
  `notes_fr` TEXT NULL ,
 - 
 
82 
  `preference` TINYINT(1)  NULL COMMENT '1 = PREFERED TERM\n0 = DISALLOWED TERM\n' ,
 108 
  `preference` TINYINT(1)  NULL DEFAULT 1 COMMENT '1 = PREFERED TERM\n0 = DISALLOWED TERM\n' ,
83 
  `ce_auteur` INT NOT NULL ,
 109 
  `ce_auteur` INT NOT NULL ,
84 
  `ce_publication` INT NOT NULL ,
 110 
  `ce_publication` INT NOT NULL ,
85 
  `ce_image` INT NOT NULL ,
 111 
  `ce_image` INT NOT NULL ,
- 
 
 112 
  `notes` TEXT NULL ,
86 
  PRIMARY KEY (`id_terme`) ,
 113 
  PRIMARY KEY (`id_terme`) ,
87 
  INDEX `fk_ontologie_terme_ontologie_terme_type` (`ce_type` ASC) ,
 114 
  INDEX `fk_ontologie_terme_ontologie_terme_type` (`ce_type` ASC) ,
88 
  INDEX `fk_ontologie_terme_ontologie_auteur1` (`ce_auteur` ASC) ,
 115 
  INDEX `fk_ontologie_terme_ontologie_auteur1` (`ce_auteur` ASC) ,
89 
  INDEX `fk_ontologie_terme_ontologie_publication1` (`ce_publication` ASC) ,
 116 
  INDEX `fk_ontologie_terme_ontologie_publication1` (`ce_publication` ASC) ,
90 
  INDEX `fk_ontologie_terme_ontologie_image1` (`ce_image` ASC) ,
 117 
  INDEX `fk_ontologie_terme_ontologie_image1` (`ce_image` ASC) )
91 
  CONSTRAINT `fk_ontologie_terme_ontologie_terme_type`
 - 
 
92 
    FOREIGN KEY (`ce_type` )
 - 
 
93 
    REFERENCES `ontologie_type` (`id_type` )
 - 
 
94 
    ON DELETE NO ACTION
 - 
 
95 
    ON UPDATE NO ACTION,
 - 
 
96 
  CONSTRAINT `fk_ontologie_terme_ontologie_auteur1`
 - 
 
97 
    FOREIGN KEY (`ce_auteur` )
 - 
 
98 
    REFERENCES `ontologie_auteur` (`id_auteur` )
 - 
 
99 
    ON DELETE NO ACTION
 - 
 
100 
    ON UPDATE NO ACTION,
 - 
 
101 
  CONSTRAINT `fk_ontologie_terme_ontologie_publication1`
 - 
 
102 
    FOREIGN KEY (`ce_publication` )
 - 
 
103 
    REFERENCES `ontologie_publication` (`id_publication` )
 - 
 
104 
    ON DELETE NO ACTION
 - 
 
105 
    ON UPDATE NO ACTION,
 - 
 
106 
  CONSTRAINT `fk_ontologie_terme_ontologie_image1`
 - 
 
107 
    FOREIGN KEY (`ce_image` )
 - 
 
108 
    REFERENCES `ontologie_image` (`id_image` )
 - 
 
109 
    ON DELETE NO ACTION
 - 
 
110 
    ON UPDATE NO ACTION)
 - 
 
111 
ENGINE = MyISAM
 118 
ENGINE = MyISAM
112 
DEFAULT CHARACTER SET = utf8
 119 
DEFAULT CHARACTER SET = utf8
113 
COLLATE = utf8_general_ci;
 120 
COLLATE = utf8_general_ci;
114 
 
 121 
 
115 
 
 122 
 
116 
-- -----------------------------------------------------
 123 
-- -----------------------------------------------------
117 
-- Table `ontologie_hierarchie`
 124 
-- Table `prometheus_ontologies_hierarchie`
118 
-- -----------------------------------------------------
 125 
-- -----------------------------------------------------
119 
CREATE  TABLE IF NOT EXISTS `ontologie_hierarchie` (
 126 
CREATE  TABLE IF NOT EXISTS `prometheus_ontologies_hierarchie` (
120 
  `id_noeud` INT NOT NULL ,
 127 
  `id_noeud` INT NOT NULL ,
121 
  `id_noeud_parent` INT NOT NULL ,
 128 
  `id_noeud_parent` INT NOT NULL ,
122 
  `chemin_noms` VARCHAR(500) NOT NULL ,
 129 
  `chemin_noms` VARCHAR(500) NOT NULL ,
123 
  `chemin_ids` VARCHAR(100) NOT NULL ,
 130 
  `chemin_ids` VARCHAR(100) NOT NULL ,
124 
  `ce_terme` INT NOT NULL ,
 131 
  `ce_terme` INT NOT NULL ,
125 
  PRIMARY KEY (`id_noeud`) ,
 132 
  PRIMARY KEY (`id_noeud`) ,
126 
  INDEX `fk_ontologie_hierarchie_ontologie_terme1` (`ce_terme` ASC) ,
 133 
  INDEX `fk_ontologie_hierarchie_ontologie_terme1` (`ce_terme` ASC) )
127 
  CONSTRAINT `fk_ontologie_hierarchie_ontologie_terme1`
 - 
 
128 
    FOREIGN KEY (`ce_terme` )
 - 
 
129 
    REFERENCES `ontologie_terme` (`id_terme` )
 - 
 
130 
    ON DELETE NO ACTION
 - 
 
131 
    ON UPDATE NO ACTION)
 - 
 
132 
ENGINE = MyISAM
 134 
ENGINE = MyISAM
133 
DEFAULT CHARACTER SET = utf8
 135 
DEFAULT CHARACTER SET = utf8
134 
COLLATE = utf8_general_ci;
 136 
COLLATE = utf8_general_ci;
135 
 
 137 
 
136 
 
 138 
 
137 
-- -----------------------------------------------------
 139 
-- -----------------------------------------------------
138 
-- Table `ontologie_relation`
 140 
-- Table `prometheus_ontologies_relation`
139 
-- -----------------------------------------------------
 141 
-- -----------------------------------------------------
140 
CREATE  TABLE IF NOT EXISTS `ontologie_relation` (
 142 
CREATE  TABLE IF NOT EXISTS `prometheus_ontologies_relation` (
141 
  `id_terme_01` INT NOT NULL ,
 143 
  `id_terme_01` INT NOT NULL ,
142 
  `id_terme_02` INT NOT NULL ,
 144 
  `id_terme_02` INT NOT NULL ,
143 
  `relation` VARCHAR(45) NULL COMMENT 'Relation entre terme_01 et terme_02.' ,
 145 
  `relation` VARCHAR(45) NOT NULL COMMENT 'Relation entre terme_01 et terme_02.' ,
144 
  PRIMARY KEY (`id_terme_01`, `id_terme_02`) ,
 146 
  PRIMARY KEY (`id_terme_01`, `id_terme_02`, `relation`) ,
145 
  INDEX `fk_ontologie_relations_ontologie_terme2` (`id_terme_02` ASC) ,
 147 
  INDEX `fk_ontologie_relations_ontologie_terme2` (`id_terme_02` ASC) )
146 
  CONSTRAINT `fk_ontologie_relations_ontologie_terme1`
 - 
 
147 
    FOREIGN KEY (`id_terme_01` )
 - 
 
148 
    REFERENCES `ontologie_terme` (`id_terme` )
 - 
 
149 
    ON DELETE NO ACTION
 - 
 
150 
    ON UPDATE NO ACTION,
 - 
 
151 
  CONSTRAINT `fk_ontologie_relations_ontologie_terme2`
 - 
 
152 
    FOREIGN KEY (`id_terme_02` )
 - 
 
153 
    REFERENCES `ontologie_terme` (`id_terme` )
 - 
 
154 
    ON DELETE NO ACTION
 - 
 
155 
    ON UPDATE NO ACTION)
 - 
 
156 
ENGINE = MyISAM
 148 
ENGINE = MyISAM
157 
DEFAULT CHARACTER SET = utf8
 149 
DEFAULT CHARACTER SET = utf8
158 
COLLATE = utf8_general_ci;
 150 
COLLATE = utf8_general_ci;
- 
 
 151 
 
159 
 
 152 
 
160 
-- -----------------------------------------------------
 153 
-- -----------------------------------------------------
161 
-- Data for table `ontologie_type`
 154 
-- Data for table `prometheus_ontologies_type`
162 
-- -----------------------------------------------------
 - 
 
163 
 
 155 
-- -----------------------------------------------------
164 
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (1, 0, 'Global', NULL);
 156 
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (1, 0, 'Global', NULL);
165 
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (4, 1, 'Modificateur relatif', NULL);
 157 
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (4, 1, 'Modificateur relatif', NULL);
166 
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (5, 1, 'Valeur relative', NULL);
 158 
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (5, 1, 'Valeur relative', NULL);
167 
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (6, 1, 'Modificateur spatial', NULL);
 159 
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (6, 1, 'Modificateur spatial', NULL);
168 
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (7, 1, 'Localisateur de region', NULL);
 160 
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (7, 1, 'Localisateur de region', NULL);
169 
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (8, 1, 'Modificateur temporel', NULL);
 161 
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (8, 1, 'Modificateur temporel', NULL);
170 
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (9, 1, 'Unité', NULL);
 162 
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (9, 1, 'Unité', NULL);
171 
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (10, 1, 'Propriété quantitative', NULL);
 163 
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (10, 1, 'Propriété quantitative', NULL);
172 
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (11, 1, 'Propriété quantitative redéfinie', NULL);
 164 
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (11, 1, 'Propriété quantitative redéfinie', NULL);
173 
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (12, 0, 'Botanique', NULL);
 165 
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (12, 0, 'Botanique', NULL);
174 
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (13, 12, 'État qualitatif', NULL);
 166 
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (13, 12, 'État qualitatif', NULL);
175 
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (14, 12, 'Type de structure', NULL);
 167 
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (14, 12, 'Type de structure', NULL);
176 
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (15, 12, 'Structure', NULL);
 168 
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (15, 12, 'Structure', NULL);
177 
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (16, 12, 'Région', NULL);
 169 
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (16, 12, 'Région', NULL);
178 
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (17, 12, 'Structure générique', NULL);
 170 
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (17, 12, 'Structure générique', NULL);
179 
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (18, 12, 'Groupe d\'états', NULL);
 171 
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (18, 12, 'Groupe d\'états', NULL);
180 
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (19, 18, 'Sous-groupe d\'états', NULL);
 172 
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (19, 18, 'Sous-groupe d\'états', NULL);
181 
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (2, 1, 'Modificateur de fréquence', NULL);
 173 
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (2, 1, 'Modificateur de fréquence', NULL);
- 
 
 174 
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (3, 1, 'Qualificateur', NULL);
182 
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (3, 1, 'Qualificateur', NULL);
 175 
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (20, 12, 'Terme déconseillé', NULL);