Subversion Repositories eFlore/Archives.herbiers

Compare Revisions

No changes between revisions

Ignore whitespace Rev 24 → Rev 25

/trunk/doc/bdd/herbiers.sql
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