Subversion Repositories eFlore/Projets.eflore-projets

Rev

Rev 227 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 227 Rev 235
Line -... Line 1...
- 
 
 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`) )
Line 11... Line 48...
11 
DEFAULT CHARACTER SET = utf8
 48 
DEFAULT CHARACTER SET = utf8
12 
COLLATE = utf8_general_ci;
 49 
COLLATE = utf8_general_ci;
Line 13... Line 50...
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 ,
Line 27... Line 64...
27 
DEFAULT CHARACTER SET = utf8
 64 
DEFAULT CHARACTER SET = utf8
28 
COLLATE = utf8_general_ci;
 65 
COLLATE = utf8_general_ci;
Line 29... Line 66...
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`) ,
 - 
 
41 
  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
 77 
  PRIMARY KEY (`id_publication`) ,
46 
    ON UPDATE NO ACTION)
 78 
  INDEX `fk_ontologie_publication_ontologie_auteur1` (`ce_auteur_principal` ASC) )
47 
ENGINE = MyISAM
 79 
ENGINE = MyISAM
Line 48... Line 80...
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 ,
 - 
 
58 
  `ce_publication` INT NOT NULL ,
 - 
 
59 
  PRIMARY KEY (`id_image`) ,
 - 
 
60 
  INDEX `fk_ontologie_image_ontologie_publication1` (`ce_publication` ASC) ,
 - 
 
61 
  CONSTRAINT `fk_ontologie_image_ontologie_publication1`
 - 
 
62 
    FOREIGN KEY (`ce_publication` )
 89 
  `uri` VARCHAR(255) NULL ,
63 
    REFERENCES `ontologie_publication` (`id_publication` )
 90 
  `ce_publication` INT NOT NULL ,
64 
    ON DELETE NO ACTION
 91 
  PRIMARY KEY (`id_image`) ,
Line 65... Line 92...
65 
    ON UPDATE NO ACTION)
 92 
  INDEX `fk_ontologie_image_ontologie_publication1` (`ce_publication` ASC) )
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)' ,
 - 
 
76 
  `ce_type` INT NOT NULL ,
 102 
  `id_terme` INT NOT NULL COMMENT 'Identifiant global du terme (GLOBALID)' ,
77 
  `terme` VARCHAR(255) NOT NULL ,
 103 
  `ce_type` INT NOT NULL ,
78 
  `definition` TEXT NULL ,
 104 
  `nom` VARCHAR(255) NOT NULL ,
79 
  `terme_fr` VARCHAR(255) NULL ,
 105 
  `description` TEXT NULL ,
- 
 
 106 
  `nom_en` VARCHAR(255) NULL ,
80 
  `definition_fr` TEXT NULL ,
 107 
  `description_en` TEXT NULL ,
81 
  `notes_fr` TEXT NULL ,
 108 
  `preference` TINYINT(1)  NULL DEFAULT 1 COMMENT '1 = PREFERED TERM\n0 = DISALLOWED TERM\n' ,
82 
  `preference` TINYINT(1)  NULL COMMENT '1 = PREFERED TERM\n0 = DISALLOWED TERM\n' ,
 109 
  `ce_auteur` INT NOT NULL ,
83 
  `ce_auteur` INT NOT NULL ,
 110 
  `ce_publication` INT NOT NULL ,
84 
  `ce_publication` INT NOT NULL ,
 111 
  `ce_image` INT NOT NULL ,
85 
  `ce_image` INT NOT NULL ,
 - 
 
86 
  PRIMARY KEY (`id_terme`) ,
 - 
 
87 
  INDEX `fk_ontologie_terme_ontologie_terme_type` (`ce_type` ASC) ,
 - 
 
88 
  INDEX `fk_ontologie_terme_ontologie_auteur1` (`ce_auteur` ASC) ,
 - 
 
89 
  INDEX `fk_ontologie_terme_ontologie_publication1` (`ce_publication` ASC) ,
 - 
 
90 
  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,
 112 
  `notes` TEXT NULL ,
106 
  CONSTRAINT `fk_ontologie_terme_ontologie_image1`
 113 
  PRIMARY KEY (`id_terme`) ,
107 
    FOREIGN KEY (`ce_image` )
 114 
  INDEX `fk_ontologie_terme_ontologie_terme_type` (`ce_type` ASC) ,
Line 108... Line 115...
108 
    REFERENCES `ontologie_image` (`id_image` )
 115 
  INDEX `fk_ontologie_terme_ontologie_auteur1` (`ce_auteur` ASC) ,
109 
    ON DELETE NO ACTION
 116 
  INDEX `fk_ontologie_terme_ontologie_publication1` (`ce_publication` ASC) ,
110 
    ON UPDATE NO ACTION)
 117 
  INDEX `fk_ontologie_terme_ontologie_image1` (`ce_image` ASC) )
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` (
 - 
 
120 
  `id_noeud` INT NOT NULL ,
 - 
 
121 
  `id_noeud_parent` INT NOT NULL ,
 - 
 
122 
  `chemin_noms` VARCHAR(500) NOT NULL ,
 - 
 
123 
  `chemin_ids` VARCHAR(100) NOT NULL ,
 - 
 
124 
  `ce_terme` INT NOT NULL ,
 126 
CREATE  TABLE IF NOT EXISTS `prometheus_ontologies_hierarchie` (
125 
  PRIMARY KEY (`id_noeud`) ,
 127 
  `id_noeud` INT NOT NULL ,
126 
  INDEX `fk_ontologie_hierarchie_ontologie_terme1` (`ce_terme` ASC) ,
 128 
  `id_noeud_parent` INT NOT NULL ,
Line 127... Line 129...
127 
  CONSTRAINT `fk_ontologie_hierarchie_ontologie_terme1`
 129 
  `chemin_noms` VARCHAR(500) NOT NULL ,
128 
    FOREIGN KEY (`ce_terme` )
 130 
  `chemin_ids` VARCHAR(100) NOT NULL ,
129 
    REFERENCES `ontologie_terme` (`id_terme` )
 131 
  `ce_terme` INT NOT NULL ,
130 
    ON DELETE NO ACTION
 132 
  PRIMARY KEY (`id_noeud`) ,
131 
    ON UPDATE NO ACTION)
 133 
  INDEX `fk_ontologie_hierarchie_ontologie_terme1` (`ce_terme` ASC) )
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 
 
 - 
 
137 
-- -----------------------------------------------------
 - 
 
138 
-- Table `ontologie_relation`
 - 
 
139 
-- -----------------------------------------------------
 - 
 
140 
CREATE  TABLE IF NOT EXISTS `ontologie_relation` (
 - 
 
141 
  `id_terme_01` INT NOT NULL ,
 - 
 
142 
  `id_terme_02` INT NOT NULL ,
 - 
 
143 
  `relation` VARCHAR(45) NULL COMMENT 'Relation entre terme_01 et terme_02.' ,
 - 
 
144 
  PRIMARY KEY (`id_terme_01`, `id_terme_02`) ,
 - 
 
145 
  INDEX `fk_ontologie_relations_ontologie_terme2` (`id_terme_02` ASC) ,
 - 
 
146 
  CONSTRAINT `fk_ontologie_relations_ontologie_terme1`
 138 
 
147 
    FOREIGN KEY (`id_terme_01` )
 139 
-- -----------------------------------------------------
148 
    REFERENCES `ontologie_terme` (`id_terme` )
 140 
-- Table `prometheus_ontologies_relation`
Line -... Line 141...
- 
 
 141 
-- -----------------------------------------------------
149 
    ON DELETE NO ACTION
 142 
CREATE  TABLE IF NOT EXISTS `prometheus_ontologies_relation` (
150 
    ON UPDATE NO ACTION,
 143 
  `id_terme_01` INT NOT NULL ,
151 
  CONSTRAINT `fk_ontologie_relations_ontologie_terme2`
 144 
  `id_terme_02` INT NOT NULL ,
152 
    FOREIGN KEY (`id_terme_02` )
 - 
 
153 
    REFERENCES `ontologie_terme` (`id_terme` )
 145 
  `relation` VARCHAR(45) NOT NULL COMMENT 'Relation entre terme_01 et terme_02.' ,
154 
    ON DELETE NO ACTION
 146 
  PRIMARY KEY (`id_terme_01`, `id_terme_02`, `relation`) ,
155 
    ON UPDATE NO ACTION)
 147 
  INDEX `fk_ontologie_relations_ontologie_terme2` (`id_terme_02` ASC) )
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;
159 
 
 151 
 
160 
-- -----------------------------------------------------
 152 
 
161 
-- Data for table `ontologie_type`
 153 
-- -----------------------------------------------------
162 
-- -----------------------------------------------------
 154 
-- Data for table `prometheus_ontologies_type`
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);
- 
 
 164 
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (11, 1, 'Propriété quantitative redéfinie', NULL);
172 
INSERT INTO ontologie_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (11, 1, 'Propriété quantitative redéfinie', NULL);
 165 
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (12, 0, 'Botanique', NULL);