New file |
0,0 → 1,355 |
-- phpMyAdmin SQL Dump |
-- version 2.11.7 |
-- http://www.phpmyadmin.net |
-- |
-- Serveur: localhost |
-- Généré le : Mer 17 Décembre 2008 à 12:30 |
-- Version du serveur: 5.0.45 |
-- Version de PHP: 5.2.6 |
|
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; |
|
-- |
-- Base de données: `tela_prod_herbiers` |
-- |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `EFLORE_DROIT` |
-- |
|
CREATE TABLE IF NOT EXISTS `EFLORE_DROIT` ( |
`ED_ID_DROIT` int(11) NOT NULL default '0', |
`ED_INTITULE_DROIT` varchar(50) NOT NULL default '', |
`ED_DESCRIPTION_DROIT` varchar(255) NOT NULL default '', |
PRIMARY KEY (`ED_ID_DROIT`), |
UNIQUE KEY `EFLORE_DROIT_PK` (`ED_ID_DROIT`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `EFLORE_DROIT_POSSEDER` |
-- |
|
CREATE TABLE IF NOT EXISTS `EFLORE_DROIT_POSSEDER` ( |
`EDP_ID_UTILISATEUR` int(11) NOT NULL default '0', |
`EDP_ID_PROJET` int(11) NOT NULL default '0', |
`EDP_ID_DROIT` int(11) NOT NULL default '0', |
PRIMARY KEY (`EDP_ID_UTILISATEUR`,`EDP_ID_DROIT`,`EDP_ID_PROJET`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `EFLORE_PROJET` |
-- |
|
CREATE TABLE IF NOT EXISTS `EFLORE_PROJET` ( |
`EPR_ID_PROJET` int(11) NOT NULL default '0', |
`EPR_CE_TYPE_PROJET_ORIGINE` int(11) NOT NULL default '0', |
`EPR_CE_OUVRAGE_SOURCE` int(11) default NULL, |
`EPR_INTITULE_PROJET` varchar(255) NOT NULL default '', |
`EPR_ABREVIATION_PROJET` varchar(40) default NULL, |
`EPR_DESCRIPTION_PROJET` varchar(255) default NULL, |
`EPR_LIEN_WEB` varchar(255) default NULL, |
`EPR_NOTES_PROJET` text, |
PRIMARY KEY (`EPR_ID_PROJET`), |
UNIQUE KEY `EFLORE_PROJET_PK` (`EPR_ID_PROJET`), |
KEY `POSSEDER_TYPE_PROJET_FK` (`EPR_CE_TYPE_PROJET_ORIGINE`), |
KEY `ETRE_BASE_SUR_OUVRAGE_FK` (`EPR_CE_OUVRAGE_SOURCE`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `gen_COUNTRY` |
-- |
|
CREATE TABLE IF NOT EXISTS `gen_COUNTRY` ( |
`GC_ID` varchar(5) NOT NULL default '', |
`GC_LOCALE` varchar(5) NOT NULL default '', |
`GC_NAME` varchar(80) NOT NULL default '', |
`GC_CAPITAL` varchar(80) NOT NULL default '', |
`GC_CONTINENT_ID` int(11) NOT NULL default '0', |
PRIMARY KEY (`GC_ID`,`GC_LOCALE`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `HERBIERS_ADMINISTRER` |
-- |
|
CREATE TABLE IF NOT EXISTS `HERBIERS_ADMINISTRER` ( |
`HA_ID_ANNUAIRE` int(10) unsigned NOT NULL default '0', |
`HA_ID_ORG` int(10) unsigned NOT NULL default '0', |
PRIMARY KEY (`HA_ID_ANNUAIRE`,`HA_ID_ORG`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `HERBIERS_A_UN_TYPE` |
-- |
|
CREATE TABLE IF NOT EXISTS `HERBIERS_A_UN_TYPE` ( |
`ID_INDIC` int(11) NOT NULL default '0', |
`ID_TYPE` int(11) NOT NULL default '0', |
PRIMARY KEY (`ID_INDIC`,`ID_TYPE`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `HERBIERS_COLLECTION` |
-- |
|
CREATE TABLE IF NOT EXISTS `HERBIERS_COLLECTION` ( |
`ID` int(11) NOT NULL auto_increment, |
`PARENT_ID` int(11) default NULL, |
`LEVEL` varchar(255) default NULL, |
`COLLECTION_CODE` varchar(64) default NULL, |
`NOM_COLLECTION` varchar(255) NOT NULL default '', |
`DESCRIPTION` text, |
`STATUT` tinyint(3) unsigned NOT NULL default '1', |
`URL` varchar(255) default NULL, |
`INCLUDED_TYPE` tinyint(4) default '0', |
`STRENGTH` text, |
`PURPOSE` text, |
`NUM_ORGANISATION` int(11) default NULL, |
`NUM_SPECIMENS` int(11) default NULL, |
`NUM_SPECIES` int(11) default NULL, |
`DOC_STATE` text, |
`PERCENT_DATABASED` smallint(6) default NULL, |
`BIOCASE_URL` varchar(255) default NULL, |
`ACCESS_RESTRICTION` text, |
`USAGE_RESTRICTION` text, |
`COLLECTION_ACTIVITY` varchar(255) default NULL, |
`COLLECTION_FOCUS` varchar(255) default NULL, |
`NOTES` text, |
`COLLECTION_CLASS` tinyint(3) unsigned NOT NULL default '1', |
`COLLECTEURS` text, |
`DATE_DEBUT` date default '0000-00-00', |
`DATE_FIN` date default '0000-00-00', |
`DATE_DEBUT_CARAC` tinyint(3) unsigned NOT NULL default '1', |
`DATE_FIN_CARAC` tinyint(3) unsigned NOT NULL default '1', |
`PREC_SPECIMENS` tinyint(3) unsigned NOT NULL default '3', |
`PREC_SPECIES` tinyint(3) unsigned NOT NULL default '3', |
`ETAT_SPECIMENS` enum('1','2','3','4') NOT NULL default '1', |
`ETAT_CLASSEMENT` enum('1','2','3','4') NOT NULL default '1', |
`ETAT_PRESENTATION` enum('1','2','3','4') NOT NULL default '1', |
`MODE_CLASSEMENT` text, |
`DATE_DERNIERE_MODIF` datetime NOT NULL default '0000-00-00 00:00:00', |
`CE_MODIFIER_PAR` int(11) NOT NULL default '0', |
PRIMARY KEY (`ID`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=352 ; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `HERBIERS_COLL_STATUT` |
-- |
|
CREATE TABLE IF NOT EXISTS `HERBIERS_COLL_STATUT` ( |
`ID_COLL_STATUT` tinyint(3) unsigned NOT NULL auto_increment, |
`LABEL` varchar(255) NOT NULL default '', |
PRIMARY KEY (`ID_COLL_STATUT`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `HERBIERS_COORDONNE` |
-- |
|
CREATE TABLE IF NOT EXISTS `HERBIERS_COORDONNE` ( |
`HC_ID_COORDINATEUR` int(10) unsigned NOT NULL default '0', |
`HC_ID_REDACTEUR` int(10) unsigned NOT NULL default '0', |
PRIMARY KEY (`HC_ID_COORDINATEUR`,`HC_ID_REDACTEUR`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `HERBIERS_DATE_DEBUT_CARAC` |
-- |
|
CREATE TABLE IF NOT EXISTS `HERBIERS_DATE_DEBUT_CARAC` ( |
`ID_DATE_CARAC` tinyint(3) unsigned NOT NULL default '0', |
`LABEL_DATE_DEBUT_CARAC` varchar(255) default NULL, |
PRIMARY KEY (`ID_DATE_CARAC`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `HERBIERS_DATE_FIN_CARAC` |
-- |
|
CREATE TABLE IF NOT EXISTS `HERBIERS_DATE_FIN_CARAC` ( |
`ID_DATE_CARAC` tinyint(3) unsigned NOT NULL default '0', |
`LABEL_DATE_FIN_CARAC` varchar(255) default NULL, |
PRIMARY KEY (`ID_DATE_CARAC`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `HERBIERS_DENOMBREMENT_CARAC_SC` |
-- |
|
CREATE TABLE IF NOT EXISTS `HERBIERS_DENOMBREMENT_CARAC_SC` ( |
`HDC_ID` tinyint(3) unsigned NOT NULL default '0', |
`HDC_LABEL` varchar(255) default NULL, |
PRIMARY KEY (`HDC_ID`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `HERBIERS_DENOMBREMENT_CARAC_SP` |
-- |
|
CREATE TABLE IF NOT EXISTS `HERBIERS_DENOMBREMENT_CARAC_SP` ( |
`HDC_ID` tinyint(3) unsigned NOT NULL default '0', |
`HDC_LABEL` varchar(255) default NULL, |
PRIMARY KEY (`HDC_ID`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `HERBIERS_INDIC` |
-- |
|
CREATE TABLE IF NOT EXISTS `HERBIERS_INDIC` ( |
`ID_INDIC` int(11) NOT NULL auto_increment, |
`ID` int(11) NOT NULL default '0', |
`REM_INDIC` text, |
`MAJ_INDIC` int(11) default NULL, |
`TXT_INDIC` text, |
PRIMARY KEY (`ID_INDIC`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=143 ; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `HERBIERS_INDIC_HISTORIQUE` |
-- |
|
CREATE TABLE IF NOT EXISTS `HERBIERS_INDIC_HISTORIQUE` ( |
`ID_INDIC_HIST` int(10) unsigned NOT NULL auto_increment, |
`ID_INDIC` int(10) unsigned NOT NULL default '0', |
`DATE_INDIC` int(10) unsigned NOT NULL default '0', |
`ID_INDICATEUR` int(10) unsigned NOT NULL default '0', |
PRIMARY KEY (`ID_INDIC_HIST`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=191 ; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `HERBIERS_ont_pres` |
-- |
|
CREATE TABLE IF NOT EXISTS `HERBIERS_ont_pres` ( |
`ID` int(10) unsigned NOT NULL default '0', |
`ID_PRES` int(10) unsigned NOT NULL default '0', |
PRIMARY KEY (`ID`,`ID_PRES`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `HERBIERS_ont_un_staff` |
-- |
|
CREATE TABLE IF NOT EXISTS `HERBIERS_ont_un_staff` ( |
`ID_ORG` int(11) NOT NULL default '0', |
`ID_STAFF` int(11) NOT NULL default '0', |
PRIMARY KEY (`ID_ORG`,`ID_STAFF`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `HERBIERS_ORGANISATION` |
-- |
|
CREATE TABLE IF NOT EXISTS `HERBIERS_ORGANISATION` ( |
`ID_ORG` int(11) NOT NULL auto_increment, |
`NUM_COLLECTION` int(11) default NULL, |
`ADRESS_TEXT` text, |
`INSTITUTION_NAME` text, |
`ADRESS_LINE` text, |
`TOWN` varchar(255) default NULL, |
`REGION` varchar(255) default NULL, |
`COUNTRY_CODE` char(3) default NULL, |
`ZIP` varchar(16) default NULL, |
`TEL` varchar(64) default NULL, |
`FAX` varchar(64) default NULL, |
`EMAIL` varchar(255) default NULL, |
`HO_URL` varchar(255) default 'http://', |
`LOGO` varchar(255) default NULL, |
`TIME_ZONE` varchar(255) default NULL, |
`ORGANISATION_CLASS` enum('Botanic_Garden','Zoo','Hoticultural','Museum','Herbarium','Laboratory','Other') NOT NULL default 'Botanic_Garden', |
`COLLECTION_CLASS` enum('living','dormant','culture','preserved','observations','photography','fossil','other') NOT NULL default 'living', |
`INDEX_HERB` varchar(16) default NULL, |
`ACCESS_RESTRICTION` text, |
`STATUT_PUBLICATION` tinyint(3) unsigned NOT NULL default '0', |
`SOURCE_DES_DONNEES` varchar(255) NOT NULL default 'IH - Index Herbariorum', |
`DATE_DERNIERE_MODIF` datetime NOT NULL default '0000-00-00 00:00:00', |
`CE_MODIFIER_PAR` int(11) NOT NULL default '0', |
PRIMARY KEY (`ID_ORG`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=102 ; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `HERBIERS_PRES` |
-- |
|
CREATE TABLE IF NOT EXISTS `HERBIERS_PRES` ( |
`ID_PRES` int(10) unsigned NOT NULL auto_increment, |
`LABEL` varchar(255) NOT NULL default '', |
`LABEL_ANG` varchar(255) NOT NULL default '', |
PRIMARY KEY (`ID_PRES`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `HERBIERS_STAFF` |
-- |
|
CREATE TABLE IF NOT EXISTS `HERBIERS_STAFF` ( |
`ID_STAFF` int(11) NOT NULL auto_increment, |
`NOM` varchar(255) default NULL, |
`PRENOM` varchar(255) default NULL, |
`ADRESSE1` varchar(255) default NULL, |
`ADRESSE2` varchar(255) default NULL, |
`CP` varchar(10) default NULL, |
`VILLE` varchar(255) default NULL, |
`MAIL` varchar(255) default NULL, |
`TEL` varchar(64) NOT NULL default '', |
`FAX` varchar(64) NOT NULL default '', |
`ID_TELA_BOTANICA` int(11) default NULL, |
`FONCTION` varchar(255) default NULL, |
`CONTACT` enum('non','oui') NOT NULL default 'non', |
`DATE_DERNIERE_MODIF` datetime NOT NULL default '0000-00-00 00:00:00', |
`CE_MODIFIER_PAR` mediumint(9) NOT NULL default '0', |
PRIMARY KEY (`ID_STAFF`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=89 ; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `HERBIERS_TYPE` |
-- |
|
CREATE TABLE IF NOT EXISTS `HERBIERS_TYPE` ( |
`ID_TYPE` int(11) NOT NULL auto_increment, |
`LABEL_TYPE` varchar(255) default NULL, |
PRIMARY KEY (`ID_TYPE`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ; |
Property changes: |
Added: svn:mergeinfo |