Subversion Repositories eFlore/Projets.eflore-projets

Rev

Rev 880 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
235 jpm 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
 
224 jpm 38
-- -----------------------------------------------------
235 jpm 39
-- Table `prometheus_ontologies_type`
224 jpm 40
-- -----------------------------------------------------
235 jpm 41
CREATE  TABLE IF NOT EXISTS `prometheus_ontologies_type` (
224 jpm 42
  `id_type` INT NOT NULL ,
43
  `id_type_parent` INT NOT NULL DEFAULT 0 ,
44
  `type` VARCHAR(45) NULL ,
45
  `description` TEXT NULL ,
46
  PRIMARY KEY (`id_type`) )
47
ENGINE = MyISAM
48
DEFAULT CHARACTER SET = utf8
49
COLLATE = utf8_general_ci;
50
 
51
 
52
-- -----------------------------------------------------
235 jpm 53
-- Table `prometheus_ontologies_auteur`
224 jpm 54
-- -----------------------------------------------------
235 jpm 55
CREATE  TABLE IF NOT EXISTS `prometheus_ontologies_auteur` (
224 jpm 56
  `id_auteur` INT NOT NULL ,
57
  `prenom` VARCHAR(45) NULL ,
58
  `nom` VARCHAR(45) NULL ,
59
  `pseudo` VARCHAR(90) NULL ,
60
  `naissance_date` DATE NULL ,
61
  `deces_date` DATE NULL ,
62
  PRIMARY KEY (`id_auteur`) )
63
ENGINE = MyISAM
64
DEFAULT CHARACTER SET = utf8
65
COLLATE = utf8_general_ci;
66
 
67
 
68
-- -----------------------------------------------------
235 jpm 69
-- Table `prometheus_ontologies_publication`
224 jpm 70
-- -----------------------------------------------------
235 jpm 71
CREATE  TABLE IF NOT EXISTS `prometheus_ontologies_publication` (
224 jpm 72
  `id_publication` INT NOT NULL ,
73
  `ce_auteur_principal` INT NOT NULL ,
74
  `titre` VARCHAR(255) NULL ,
75
  `date` DATE NULL ,
76
  `uri` VARCHAR(255) NULL ,
77
  PRIMARY KEY (`id_publication`) ,
235 jpm 78
  INDEX `fk_ontologie_publication_ontologie_auteur1` (`ce_auteur_principal` ASC) )
224 jpm 79
ENGINE = MyISAM
80
DEFAULT CHARACTER SET = utf8
81
COLLATE = utf8_general_ci;
82
 
83
 
84
-- -----------------------------------------------------
235 jpm 85
-- Table `prometheus_ontologies_image`
224 jpm 86
-- -----------------------------------------------------
235 jpm 87
CREATE  TABLE IF NOT EXISTS `prometheus_ontologies_image` (
224 jpm 88
  `id_image` INT NOT NULL ,
89
  `uri` VARCHAR(255) NULL ,
90
  `ce_publication` INT NOT NULL ,
91
  PRIMARY KEY (`id_image`) ,
235 jpm 92
  INDEX `fk_ontologie_image_ontologie_publication1` (`ce_publication` ASC) )
224 jpm 93
ENGINE = MyISAM
94
DEFAULT CHARACTER SET = utf8
95
COLLATE = utf8_general_ci;
96
 
97
 
98
-- -----------------------------------------------------
235 jpm 99
-- Table `prometheus_ontologies_terme`
224 jpm 100
-- -----------------------------------------------------
235 jpm 101
CREATE  TABLE IF NOT EXISTS `prometheus_ontologies_terme` (
224 jpm 102
  `id_terme` INT NOT NULL COMMENT 'Identifiant global du terme (GLOBALID)' ,
103
  `ce_type` INT NOT NULL ,
235 jpm 104
  `nom` VARCHAR(255) NOT NULL ,
105
  `description` TEXT NULL ,
106
  `nom_en` VARCHAR(255) NULL ,
107
  `description_en` TEXT NULL ,
108
  `preference` TINYINT(1)  NULL DEFAULT 1 COMMENT '1 = PREFERED TERM\n0 = DISALLOWED TERM\n' ,
224 jpm 109
  `ce_auteur` INT NOT NULL ,
110
  `ce_publication` INT NOT NULL ,
111
  `ce_image` INT NOT NULL ,
235 jpm 112
  `notes` TEXT NULL ,
224 jpm 113
  PRIMARY KEY (`id_terme`) ,
114
  INDEX `fk_ontologie_terme_ontologie_terme_type` (`ce_type` ASC) ,
115
  INDEX `fk_ontologie_terme_ontologie_auteur1` (`ce_auteur` ASC) ,
116
  INDEX `fk_ontologie_terme_ontologie_publication1` (`ce_publication` ASC) ,
235 jpm 117
  INDEX `fk_ontologie_terme_ontologie_image1` (`ce_image` ASC) )
224 jpm 118
ENGINE = MyISAM
119
DEFAULT CHARACTER SET = utf8
120
COLLATE = utf8_general_ci;
121
 
122
 
123
-- -----------------------------------------------------
235 jpm 124
-- Table `prometheus_ontologies_hierarchie`
224 jpm 125
-- -----------------------------------------------------
235 jpm 126
CREATE  TABLE IF NOT EXISTS `prometheus_ontologies_hierarchie` (
224 jpm 127
  `id_noeud` INT NOT NULL ,
128
  `id_noeud_parent` INT NOT NULL ,
129
  `chemin_noms` VARCHAR(500) NOT NULL ,
130
  `chemin_ids` VARCHAR(100) NOT NULL ,
131
  `ce_terme` INT NOT NULL ,
132
  PRIMARY KEY (`id_noeud`) ,
235 jpm 133
  INDEX `fk_ontologie_hierarchie_ontologie_terme1` (`ce_terme` ASC) )
224 jpm 134
ENGINE = MyISAM
135
DEFAULT CHARACTER SET = utf8
136
COLLATE = utf8_general_ci;
137
 
138
 
139
-- -----------------------------------------------------
235 jpm 140
-- Table `prometheus_ontologies_relation`
224 jpm 141
-- -----------------------------------------------------
235 jpm 142
CREATE  TABLE IF NOT EXISTS `prometheus_ontologies_relation` (
224 jpm 143
  `id_terme_01` INT NOT NULL ,
144
  `id_terme_02` INT NOT NULL ,
235 jpm 145
  `relation` VARCHAR(45) NOT NULL COMMENT 'Relation entre terme_01 et terme_02.' ,
146
  PRIMARY KEY (`id_terme_01`, `id_terme_02`, `relation`) ,
147
  INDEX `fk_ontologie_relations_ontologie_terme2` (`id_terme_02` ASC) )
224 jpm 148
ENGINE = MyISAM
149
DEFAULT CHARACTER SET = utf8
150
COLLATE = utf8_general_ci;
151
 
235 jpm 152
 
224 jpm 153
-- -----------------------------------------------------
235 jpm 154
-- Data for table `prometheus_ontologies_type`
224 jpm 155
-- -----------------------------------------------------
235 jpm 156
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (1, 0, 'Global', NULL);
157
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (4, 1, 'Modificateur relatif', NULL);
158
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (5, 1, 'Valeur relative', NULL);
159
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (6, 1, 'Modificateur spatial', NULL);
160
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (7, 1, 'Localisateur de region', NULL);
161
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (8, 1, 'Modificateur temporel', NULL);
162
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (9, 1, 'Unité', 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);
165
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (12, 0, 'Botanique', NULL);
166
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (13, 12, 'État qualitatif', NULL);
167
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (14, 12, 'Type de structure', NULL);
168
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (15, 12, 'Structure', NULL);
169
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (16, 12, 'Région', NULL);
170
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (17, 12, 'Structure générique', NULL);
171
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (18, 12, '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);
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);
175
INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (20, 12, 'Terme déconseillé', NULL);