Subversion Repositories eFlore/Archives.herbiers

-- 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 ;