Blame | Last modification | View Log | RSS feed
-- 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.0SET 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;