Subversion Repositories Applications.projet

Compare Revisions

Ignore whitespace Rev 1 → Rev 2

/trunk/documentation/projet.sql
New file
0,0 → 1,108
CREATE TABLE `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 '',
PRIMARY KEY (`p_id`)
);
 
CREATE TABLE `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`)
);
 
 
CREATE TABLE `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`)
);
 
CREATE TABLE `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`)
);
 
 
CREATE TABLE `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',
PRIMARY KEY (`pil_id_liste`,`pil_id_utilisateur`)
);
 
 
CREATE TABLE `projet_lien_liste` (
`pl_id_liste` int(10) unsigned NOT NULL default '0',
`pl_id_projet` int(10) unsigned NOT NULL default '0'
);
 
 
CREATE TABLE `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`)
);
 
CREATE TABLE `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`)
);
 
 
CREATE TABLE `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`)
);
 
INSERT INTO `projet_liste_statut` VALUES (0, 'Pas d''email');
INSERT INTO `projet_liste_statut` VALUES (2, 'Email');
CREATE TABLE `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`)
);
 
INSERT INTO `projet_statut` VALUES (0, 'Administrateur');
INSERT INTO `projet_statut` VALUES (1, 'Coordonateur');
INSERT INTO `projet_statut` VALUES (2, 'Participant');
CREATE TABLE `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`)
);