Subversion Repositories eFlore/Projets.eflore-projets

--

-- Structure de la table `prometheus_meta`

--

CREATE TABLE IF NOT EXISTS `prometheus_meta` (

  `guid` varchar(255) NOT NULL DEFAULT 'urn:lsid:tela-botanica.org:#projet:#version',

  `langue_meta` varchar(2) NOT NULL DEFAULT 'fr',

  `code` varchar(20) NOT NULL,

  `version` varchar(20) NOT NULL,

  `titre` varchar(255) DEFAULT NULL,

  `description` text,

  `mots_cles` varchar(510) DEFAULT NULL,

  `citation` varchar(255) DEFAULT NULL,

  `url_tech` varchar(510) DEFAULT NULL,

  `url_projet` varchar(510) DEFAULT NULL,

  `source` text,

  `createurs` text,

  `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;',

  `contributeurs` text,

  `droits` text,

  `url_droits` varchar(510) DEFAULT NULL,

  `langue` varchar(255) NOT NULL DEFAULT 'fr',

  `date_creation` varchar(30) NOT NULL DEFAULT 'YYYY-MM-DD',

  `date_validite` varchar(255) DEFAULT NULL,

  `couverture_spatiale` varchar(510) NOT NULL DEFAULT 'iso-3166-1.id=FX;',

  `couverture_temporelle` varchar(510) DEFAULT NULL,

  `web_services` varchar(510) DEFAULT NULL COMMENT 'ontologies,meta-donnees,noms,taxons,aide,textes,images,observations,noms-vernaculaires',

  PRIMARY KEY (`guid`,`langue_meta`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--

-- Contenu de la table `prometheus_meta`

--

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

('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');

-- -----------------------------------------------------

-- Table `prometheus_ontologies_type`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `prometheus_ontologies_type` (

  `id_type` INT NOT NULL ,

  `id_type_parent` INT NOT NULL DEFAULT 0 ,

  `type` VARCHAR(45) NULL ,

  `description` TEXT NULL ,

  PRIMARY KEY (`id_type`) )

ENGINE = MyISAM

DEFAULT CHARACTER SET = utf8

COLLATE = utf8_general_ci;

-- -----------------------------------------------------

-- Table `prometheus_ontologies_auteur`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `prometheus_ontologies_auteur` (

  `id_auteur` INT NOT NULL ,

  `prenom` VARCHAR(45) NULL ,

  `nom` VARCHAR(45) NULL ,

  `pseudo` VARCHAR(90) NULL ,

  `naissance_date` DATE NULL ,

  `deces_date` DATE NULL ,

  PRIMARY KEY (`id_auteur`) )

ENGINE = MyISAM

DEFAULT CHARACTER SET = utf8

COLLATE = utf8_general_ci;

-- -----------------------------------------------------

-- Table `prometheus_ontologies_publication`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `prometheus_ontologies_publication` (

  `id_publication` INT NOT NULL ,

  `ce_auteur_principal` INT NOT NULL ,

  `titre` VARCHAR(255) NULL ,

  `date` DATE NULL ,

  `uri` VARCHAR(255) NULL ,

  PRIMARY KEY (`id_publication`) ,

  INDEX `fk_ontologie_publication_ontologie_auteur1` (`ce_auteur_principal` ASC) )

ENGINE = MyISAM

DEFAULT CHARACTER SET = utf8

COLLATE = utf8_general_ci;

-- -----------------------------------------------------

-- Table `prometheus_ontologies_image`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `prometheus_ontologies_image` (

  `id_image` INT NOT NULL ,

  `uri` VARCHAR(255) NULL ,

  `ce_publication` INT NOT NULL ,

  PRIMARY KEY (`id_image`) ,

  INDEX `fk_ontologie_image_ontologie_publication1` (`ce_publication` ASC) )

ENGINE = MyISAM

DEFAULT CHARACTER SET = utf8

COLLATE = utf8_general_ci;

-- -----------------------------------------------------

-- Table `prometheus_ontologies_terme`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `prometheus_ontologies_terme` (

  `id_terme` INT NOT NULL COMMENT 'Identifiant global du terme (GLOBALID)' ,

  `ce_type` INT NOT NULL ,

  `nom` VARCHAR(255) NOT NULL ,

  `description` TEXT NULL ,

  `nom_en` VARCHAR(255) NULL ,

  `description_en` TEXT NULL ,

  `preference` TINYINT(1)  NULL DEFAULT 1 COMMENT '1 = PREFERED TERM\n0 = DISALLOWED TERM\n' ,

  `ce_auteur` INT NOT NULL ,

  `ce_publication` INT NOT NULL ,

  `ce_image` INT NOT NULL ,

  `notes` TEXT NULL ,

  PRIMARY KEY (`id_terme`) ,

  INDEX `fk_ontologie_terme_ontologie_terme_type` (`ce_type` ASC) ,

  INDEX `fk_ontologie_terme_ontologie_auteur1` (`ce_auteur` ASC) ,

  INDEX `fk_ontologie_terme_ontologie_publication1` (`ce_publication` ASC) ,

  INDEX `fk_ontologie_terme_ontologie_image1` (`ce_image` ASC) )

ENGINE = MyISAM

DEFAULT CHARACTER SET = utf8

COLLATE = utf8_general_ci;

-- -----------------------------------------------------

-- Table `prometheus_ontologies_hierarchie`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `prometheus_ontologies_hierarchie` (

  `id_noeud` INT NOT NULL ,

  `id_noeud_parent` INT NOT NULL ,

  `chemin_noms` VARCHAR(500) NOT NULL ,

  `chemin_ids` VARCHAR(100) NOT NULL ,

  `ce_terme` INT NOT NULL ,

  PRIMARY KEY (`id_noeud`) ,

  INDEX `fk_ontologie_hierarchie_ontologie_terme1` (`ce_terme` ASC) )

ENGINE = MyISAM

DEFAULT CHARACTER SET = utf8

COLLATE = utf8_general_ci;

-- -----------------------------------------------------

-- Table `prometheus_ontologies_relation`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `prometheus_ontologies_relation` (

  `id_terme_01` INT NOT NULL ,

  `id_terme_02` INT NOT NULL ,

  `relation` VARCHAR(45) NOT NULL COMMENT 'Relation entre terme_01 et terme_02.' ,

  PRIMARY KEY (`id_terme_01`, `id_terme_02`, `relation`) ,

  INDEX `fk_ontologie_relations_ontologie_terme2` (`id_terme_02` ASC) )

ENGINE = MyISAM

DEFAULT CHARACTER SET = utf8

COLLATE = utf8_general_ci;

-- -----------------------------------------------------

-- Data for table `prometheus_ontologies_type`

-- -----------------------------------------------------

INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (1, 0, 'Global', NULL);

INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (4, 1, 'Modificateur relatif', NULL);

INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (5, 1, 'Valeur relative', NULL);

INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (6, 1, 'Modificateur spatial', NULL);

INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (7, 1, 'Localisateur de region', NULL);

INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (8, 1, 'Modificateur temporel', NULL);

INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (9, 1, 'Unité', NULL);

INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (10, 1, 'Propriété quantitative', NULL);

INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (11, 1, 'Propriété quantitative redéfinie', NULL);

INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (12, 0, 'Botanique', NULL);

INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (13, 12, 'État qualitatif', NULL);

INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (14, 12, 'Type de structure', NULL);

INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (15, 12, 'Structure', NULL);

INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (16, 12, 'Région', NULL);

INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (17, 12, 'Structure générique', NULL);

INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (18, 12, 'Groupe d\'états', NULL);

INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (19, 18, 'Sous-groupe d\'états', NULL);

INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (2, 1, 'Modificateur de fréquence', NULL);

INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (3, 1, 'Qualificateur', NULL);

INSERT INTO prometheus_ontologies_type (`id_type`, `id_type_parent`, `type`, `description`) VALUES (20, 12, 'Terme déconseillé', NULL);