New file |
0,0 → 1,306 |
-- phpMyAdmin SQL Dump |
-- version 3.2.0.1 |
-- http://www.phpmyadmin.net |
-- |
-- Serveur: localhost |
-- Généré le : Jeu 10 Juin 2010 à 08:10 |
-- Version du serveur: 5.1.36 |
-- Version de PHP: 5.3.0 |
|
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; |
|
-- |
-- Base de données: `plantnet` |
-- |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `projet` |
-- |
|
CREATE TABLE IF NOT EXISTS `projet` ( |
`p_id` int(10) unsigned NOT NULL DEFAULT '0', |
`p_titre` varchar(255) NOT NULL DEFAULT '', |
`p_resume` varchar(255) NOT NULL DEFAULT '', |
`p_description` text, |
`p_espace_internet` varchar(255) DEFAULT NULL, |
`p_wikini` varchar(255) NOT NULL DEFAULT '', |
`p_date_creation` date NOT NULL DEFAULT '0000-00-00', |
`p_nom_repertoire` varchar(255) NOT NULL DEFAULT '', |
`p_type` tinyint(3) unsigned NOT NULL DEFAULT '0', |
`p_modere` tinyint(3) unsigned NOT NULL, |
`p_avoir_document` tinyint(3) unsigned NOT NULL DEFAULT '0', |
`p_nombre_participants` int(10) unsigned NOT NULL, |
`p_en_dormance` tinyint(3) unsigned NOT NULL DEFAULT '0', |
PRIMARY KEY (`p_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `projet_avoir_theme` |
-- |
|
CREATE TABLE IF NOT EXISTS `projet_avoir_theme` ( |
`pat_id_projet` int(10) unsigned NOT NULL, |
`pat_id_theme` int(10) unsigned NOT NULL, |
PRIMARY KEY (`pat_id_projet`,`pat_id_theme`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `projet_documents` |
-- |
|
CREATE TABLE IF NOT EXISTS `projet_documents` ( |
`pd_id` int(10) unsigned NOT NULL DEFAULT '0', |
`pd_ce_projet` int(10) unsigned NOT NULL DEFAULT '0', |
`pd_ce_utilisateur` int(11) DEFAULT '0', |
`pd_ce_type` int(11) NOT NULL DEFAULT '0', |
`pd_nom` varchar(255) DEFAULT NULL, |
`pd_lien` varchar(255) DEFAULT NULL, |
`pd_pere` int(10) unsigned NOT NULL DEFAULT '0', |
`pd_permissions` smallint(5) unsigned DEFAULT NULL, |
`pd_date_de_mise_a_jour` date DEFAULT NULL, |
`pd_description` text, |
`pd_visibilite` varchar(64) NOT NULL DEFAULT '', |
PRIMARY KEY (`pd_id`), |
KEY `pd_ce_projet` (`pd_ce_projet`), |
KEY `pd_date_de_mise_a_jour` (`pd_date_de_mise_a_jour`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `projet_documents_sauvegarde` |
-- |
|
CREATE TABLE IF NOT EXISTS `projet_documents_sauvegarde` ( |
`pd_id` int(10) unsigned NOT NULL DEFAULT '0', |
`pd_ce_projet` int(10) unsigned NOT NULL DEFAULT '0', |
`pd_ce_utilisateur` int(11) DEFAULT '0', |
`pd_ce_type` int(11) NOT NULL DEFAULT '0', |
`pd_nom` varchar(255) DEFAULT NULL, |
`pd_lien` varchar(255) DEFAULT NULL, |
`pd_pere` int(10) unsigned NOT NULL DEFAULT '0', |
`pd_permissions` smallint(5) unsigned DEFAULT NULL, |
`pd_date_de_mise_a_jour` date DEFAULT NULL, |
`pd_description` text, |
`pd_visibilite` varchar(64) NOT NULL DEFAULT '', |
PRIMARY KEY (`pd_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `projet_evenement` |
-- |
|
CREATE TABLE IF NOT EXISTS `projet_evenement` ( |
`pe_id` int(10) unsigned NOT NULL AUTO_INCREMENT, |
`pe_ce_utilisateur` int(11) NOT NULL DEFAULT '0', |
`pe_ce_projet` int(10) unsigned NOT NULL DEFAULT '0', |
`pe_date_debut` date DEFAULT NULL, |
`pe_titre` varchar(255) DEFAULT NULL, |
`pe_description` text, |
`pe_date_fin` date DEFAULT NULL, |
PRIMARY KEY (`pe_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `projet_hierarchie` |
-- |
|
CREATE TABLE IF NOT EXISTS `projet_hierarchie` ( |
`ph_id_projet_pere` int(10) unsigned NOT NULL DEFAULT '0', |
`ph_id_projet_fils` int(10) unsigned NOT NULL DEFAULT '0', |
PRIMARY KEY (`ph_id_projet_pere`,`ph_id_projet_fils`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `projet_inscription_liste` |
-- |
|
CREATE TABLE IF NOT EXISTS `projet_inscription_liste` ( |
`pil_id_liste` int(10) unsigned NOT NULL DEFAULT '0', |
`pil_id_utilisateur` int(10) unsigned NOT NULL DEFAULT '0', |
`pil_id_statut` tinyint(3) unsigned NOT NULL DEFAULT '0', |
`pil_date_inscription` date NOT NULL, |
PRIMARY KEY (`pil_id_liste`,`pil_id_utilisateur`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `projet_lien_forum` |
-- |
|
CREATE TABLE IF NOT EXISTS `projet_lien_forum` ( |
`PLF_ID_PROJET` int(10) unsigned NOT NULL DEFAULT '0', |
`PLF_ID_FORUM` int(10) unsigned NOT NULL DEFAULT '0', |
PRIMARY KEY (`PLF_ID_PROJET`,`PLF_ID_FORUM`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Table des qui relie les forums et les projets'; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `projet_lien_liste` |
-- |
|
CREATE TABLE IF NOT EXISTS `projet_lien_liste` ( |
`pl_id_liste` int(10) unsigned NOT NULL DEFAULT '0', |
`pl_id_projet` int(10) unsigned NOT NULL DEFAULT '0', |
PRIMARY KEY (`pl_id_liste`,`pl_id_projet`), |
KEY `pl_id_projet` (`pl_id_projet`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='table faisant le lien entre les projets et les listes de dis'; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `projet_lien_liste_externe` |
-- |
|
CREATE TABLE IF NOT EXISTS `projet_lien_liste_externe` ( |
`plle_id_projet` int(10) unsigned NOT NULL DEFAULT '0', |
`plle_id_liste` int(10) unsigned NOT NULL DEFAULT '0', |
PRIMARY KEY (`plle_id_projet`,`plle_id_liste`), |
KEY `plle_id_projet` (`plle_id_projet`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `projet_liste` |
-- |
|
CREATE TABLE IF NOT EXISTS `projet_liste` ( |
`pl_id_liste` int(10) unsigned NOT NULL AUTO_INCREMENT, |
`pl_nom_liste` varchar(255) NOT NULL DEFAULT '', |
`pl_domaine` varchar(255) NOT NULL DEFAULT '', |
`pl_adresse_liste` varchar(255) DEFAULT NULL, |
`pl_adresse_inscription` varchar(255) DEFAULT NULL, |
`pl_adresse_desinscription` varchar(255) DEFAULT NULL, |
`pl_adresse_aide` varchar(255) DEFAULT NULL, |
`pl_visibilite` tinyint(3) unsigned NOT NULL DEFAULT '0', |
PRIMARY KEY (`pl_id_liste`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=70 ; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `projet_liste_statut` |
-- |
|
CREATE TABLE IF NOT EXISTS `projet_liste_statut` ( |
`pls_id_statut` tinyint(3) unsigned NOT NULL DEFAULT '0', |
`pls_statut_nom` varchar(255) NOT NULL DEFAULT '', |
PRIMARY KEY (`pls_id_statut`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `projet_preferences_utilisateurs` |
-- |
|
CREATE TABLE IF NOT EXISTS `projet_preferences_utilisateurs` ( |
`ppu_id` int(10) unsigned DEFAULT NULL, |
`ppu_ce_utilisateur` int(11) NOT NULL, |
`ppu_preferences` text |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `projet_statistiques` |
-- |
|
CREATE TABLE IF NOT EXISTS `projet_statistiques` ( |
`ps_id` int(10) unsigned NOT NULL AUTO_INCREMENT, |
`ps_ce_projet` int(10) unsigned NOT NULL, |
`ps_msg_derniere_semaine` int(10) unsigned DEFAULT NULL, |
`ps_doc_derniere_semaine` int(10) unsigned DEFAULT NULL, |
`ps_nombre_inscrit_derniere_semaine` int(11) NOT NULL, |
`ps_nombre_inscrit` int(10) unsigned DEFAULT NULL, |
`ps_nombre_inscrit_liste` int(10) unsigned DEFAULT NULL, |
`ps_nombre_membre_yahoo` int(10) unsigned NOT NULL, |
`ps_modifwiki_derniere_semaine` int(10) unsigned DEFAULT NULL, |
`ps_date` datetime NOT NULL, |
`ps_maj` datetime NOT NULL, |
`ps_somme` float unsigned NOT NULL, |
`ps_pourcent` tinyint(3) unsigned NOT NULL, |
`ps_dernier` tinyint(3) unsigned NOT NULL, |
PRIMARY KEY (`ps_id`), |
KEY `ps_date` (`ps_date`), |
KEY `ps_ce_projet` (`ps_ce_projet`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6908 ; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `projet_statut` |
-- |
|
CREATE TABLE IF NOT EXISTS `projet_statut` ( |
`ps_id_statut` int(10) unsigned NOT NULL DEFAULT '0', |
`ps_statut_nom` varchar(255) NOT NULL DEFAULT '', |
PRIMARY KEY (`ps_id_statut`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `projet_statut_utilisateurs` |
-- |
|
CREATE TABLE IF NOT EXISTS `projet_statut_utilisateurs` ( |
`psu_id_statut` int(10) unsigned NOT NULL DEFAULT '0', |
`psu_id_utilisateur` int(11) NOT NULL DEFAULT '0', |
`psu_id_projet` int(10) unsigned NOT NULL DEFAULT '0', |
`psu_date_inscription` date DEFAULT '0000-00-00', |
PRIMARY KEY (`psu_id_statut`,`psu_id_utilisateur`,`psu_id_projet`), |
KEY `psu_id_projet` (`psu_id_projet`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `projet_template` |
-- |
|
CREATE TABLE IF NOT EXISTS `projet_template` ( |
`pt_id_template` smallint(5) unsigned NOT NULL DEFAULT '0', |
`pt_i18n` varchar(5) NOT NULL DEFAULT '', |
`pt_template` text NOT NULL, |
PRIMARY KEY (`pt_id_template`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `projet_theme` |
-- |
|
CREATE TABLE IF NOT EXISTS `projet_theme` ( |
`pt_id_theme` tinyint(3) unsigned NOT NULL DEFAULT '0', |
`pt_label_theme` varchar(255) NOT NULL, |
PRIMARY KEY (`pt_id_theme`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
|
-- -------------------------------------------------------- |
|
-- |
-- Structure de la table `projet_type` |
-- |
|
CREATE TABLE IF NOT EXISTS `projet_type` ( |
`pt_id_type` tinyint(3) unsigned NOT NULL DEFAULT '0', |
`pt_label_type` varchar(255) NOT NULL DEFAULT '', |
PRIMARY KEY (`pt_id_type`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |