Subversion Repositories Applications.papyrus

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
448 ddelon 1
CREATE TABLE `projet` (
2
  `p_id` int(10) unsigned NOT NULL default '0',
3
  `p_titre` varchar(255) NOT NULL default '',
4
  `p_resume` varchar(255) NOT NULL default '',
5
  `p_description` text,
6
  `p_espace_internet` varchar(255) default NULL,
7
  `p_wikini` varchar(255) NOT NULL default '',
8
  `p_date_creation` date NOT NULL default '0000-00-00',
9
  `p_nom_repertoire` varchar(255) NOT NULL default '',
10
  PRIMARY KEY  (`p_id`)
11
);
12
 
13
CREATE TABLE `projet_documents` (
14
  `pd_id` int(10) unsigned NOT NULL default '0',
15
  `pd_ce_projet` int(10) unsigned NOT NULL default '0',
16
  `pd_ce_utilisateur` int(11) default '0',
17
  `pd_ce_type` int(11) NOT NULL default '0',
18
  `pd_nom` varchar(255) default NULL,
19
  `pd_lien` varchar(255) default NULL,
20
  `pd_pere` int(10) unsigned NOT NULL default '0',
21
  `pd_permissions` smallint(5) unsigned default NULL,
22
  `pd_date_de_mise_a_jour` date default NULL,
23
  `pd_description` text,
24
  `pd_visibilite` varchar(64) NOT NULL default '',
25
  PRIMARY KEY  (`pd_id`)
26
);
27
 
28
 
29
CREATE TABLE `projet_evenement` (
30
  `pe_id` int(10) unsigned NOT NULL auto_increment,
31
  `pe_ce_utilisateur` int(11) NOT NULL default '0',
32
  `pe_ce_projet` int(10) unsigned NOT NULL default '0',
33
  `pe_date_debut` date default NULL,
34
  `pe_titre` varchar(255) default NULL,
35
  `pe_description` text,
36
  `pe_date_fin` date default NULL,
37
  PRIMARY KEY  (`pe_id`)
38
);
39
 
40
CREATE TABLE `projet_hierarchie` (
41
  `ph_id_projet_pere` int(10) unsigned NOT NULL default '0',
42
  `ph_id_projet_fils` int(10) unsigned NOT NULL default '0',
43
  PRIMARY KEY  (`ph_id_projet_pere`,`ph_id_projet_fils`)
44
);
45
 
46
 
47
CREATE TABLE `projet_inscription_liste` (
48
  `pil_id_liste` int(10) unsigned NOT NULL default '0',
49
  `pil_id_utilisateur` int(10) unsigned NOT NULL default '0',
50
  `pil_id_statut` tinyint(3) unsigned NOT NULL default '0',
51
  PRIMARY KEY  (`pil_id_liste`,`pil_id_utilisateur`)
52
);
53
 
54
 
55
CREATE TABLE `projet_lien_liste` (
56
  `pl_id_liste` int(10) unsigned NOT NULL default '0',
57
  `pl_id_projet` int(10) unsigned NOT NULL default '0'
58
);
59
 
60
 
61
CREATE TABLE `projet_lien_liste_externe` (
62
  `plle_id_projet` int(10) unsigned NOT NULL default '0',
63
  `plle_id_liste` int(10) unsigned NOT NULL default '0',
64
  PRIMARY KEY  (`plle_id_projet`,`plle_id_liste`)
65
);
66
 
67
CREATE TABLE `projet_liste` (
68
  `pl_id_liste` int(10) unsigned NOT NULL auto_increment,
69
  `pl_nom_liste` varchar(255) NOT NULL default '',
70
  `pl_domaine` varchar(255) NOT NULL default '',
71
  `pl_adresse_liste` varchar(255) default NULL,
72
  `pl_adresse_inscription` varchar(255) default NULL,
73
  `pl_adresse_desinscription` varchar(255) default NULL,
74
  `pl_adresse_aide` varchar(255) default NULL,
75
  `pl_visibilite` tinyint(3) unsigned NOT NULL default '0',
76
  PRIMARY KEY  (`pl_id_liste`)
77
);
78
 
79
 
80
CREATE TABLE `projet_liste_statut` (
81
  `pls_id_statut` tinyint(3) unsigned NOT NULL default '0',
82
  `pls_statut_nom` varchar(255) NOT NULL default '',
83
  PRIMARY KEY  (`pls_id_statut`)
84
);
85
 
86
INSERT INTO `projet_liste_statut` VALUES (0, 'Pas d''email');
87
INSERT INTO `projet_liste_statut` VALUES (2, 'Email');
88
 
89
CREATE TABLE `projet_statut` (
90
  `ps_id_statut` int(10) unsigned NOT NULL default '0',
91
  `ps_statut_nom` varchar(255) NOT NULL default '',
92
  PRIMARY KEY  (`ps_id_statut`)
93
);
94
 
95
INSERT INTO `projet_statut` VALUES (0, 'Administrateur');
96
INSERT INTO `projet_statut` VALUES (1, 'Coordonateur');
97
INSERT INTO `projet_statut` VALUES (2, 'Participant');
98
 
99
CREATE TABLE `projet_statut_utilisateurs` (
100
  `psu_id_statut` int(10) unsigned NOT NULL default '0',
101
  `psu_id_utilisateur` int(11) NOT NULL default '0',
102
  `psu_id_projet` int(10) unsigned NOT NULL default '0',
103
  `psu_date_inscription` date default '0000-00-00',
104
  PRIMARY KEY  (`psu_id_statut`,`psu_id_utilisateur`,`psu_id_projet`)
105
);
106
 
107
 
108