| 361 |
gduche |
1 |
-- phpMyAdmin SQL Dump
|
|
|
2 |
-- version 3.2.0.1
|
|
|
3 |
-- http://www.phpmyadmin.net
|
|
|
4 |
--
|
|
|
5 |
-- Serveur: localhost
|
|
|
6 |
-- Généré le : Jeu 10 Juin 2010 à 08:10
|
|
|
7 |
-- Version du serveur: 5.1.36
|
|
|
8 |
-- Version de PHP: 5.3.0
|
|
|
9 |
|
|
|
10 |
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
|
|
|
11 |
|
|
|
12 |
--
|
|
|
13 |
-- Base de données: `plantnet`
|
|
|
14 |
--
|
|
|
15 |
|
|
|
16 |
-- --------------------------------------------------------
|
|
|
17 |
|
|
|
18 |
--
|
|
|
19 |
-- Structure de la table `projet`
|
|
|
20 |
--
|
|
|
21 |
|
|
|
22 |
CREATE TABLE IF NOT EXISTS `projet` (
|
|
|
23 |
`p_id` int(10) unsigned NOT NULL DEFAULT '0',
|
|
|
24 |
`p_titre` varchar(255) NOT NULL DEFAULT '',
|
|
|
25 |
`p_resume` varchar(255) NOT NULL DEFAULT '',
|
|
|
26 |
`p_description` text,
|
|
|
27 |
`p_espace_internet` varchar(255) DEFAULT NULL,
|
|
|
28 |
`p_wikini` varchar(255) NOT NULL DEFAULT '',
|
|
|
29 |
`p_date_creation` date NOT NULL DEFAULT '0000-00-00',
|
|
|
30 |
`p_nom_repertoire` varchar(255) NOT NULL DEFAULT '',
|
|
|
31 |
`p_type` tinyint(3) unsigned NOT NULL DEFAULT '0',
|
|
|
32 |
`p_modere` tinyint(3) unsigned NOT NULL,
|
|
|
33 |
`p_avoir_document` tinyint(3) unsigned NOT NULL DEFAULT '0',
|
|
|
34 |
`p_nombre_participants` int(10) unsigned NOT NULL,
|
|
|
35 |
`p_en_dormance` tinyint(3) unsigned NOT NULL DEFAULT '0',
|
|
|
36 |
PRIMARY KEY (`p_id`)
|
|
|
37 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
38 |
|
|
|
39 |
-- --------------------------------------------------------
|
|
|
40 |
|
|
|
41 |
--
|
|
|
42 |
-- Structure de la table `projet_avoir_theme`
|
|
|
43 |
--
|
|
|
44 |
|
|
|
45 |
CREATE TABLE IF NOT EXISTS `projet_avoir_theme` (
|
|
|
46 |
`pat_id_projet` int(10) unsigned NOT NULL,
|
|
|
47 |
`pat_id_theme` int(10) unsigned NOT NULL,
|
|
|
48 |
PRIMARY KEY (`pat_id_projet`,`pat_id_theme`)
|
|
|
49 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
50 |
|
|
|
51 |
-- --------------------------------------------------------
|
|
|
52 |
|
|
|
53 |
--
|
|
|
54 |
-- Structure de la table `projet_documents`
|
|
|
55 |
--
|
|
|
56 |
|
|
|
57 |
CREATE TABLE IF NOT EXISTS `projet_documents` (
|
|
|
58 |
`pd_id` int(10) unsigned NOT NULL DEFAULT '0',
|
|
|
59 |
`pd_ce_projet` int(10) unsigned NOT NULL DEFAULT '0',
|
|
|
60 |
`pd_ce_utilisateur` int(11) DEFAULT '0',
|
|
|
61 |
`pd_ce_type` int(11) NOT NULL DEFAULT '0',
|
|
|
62 |
`pd_nom` varchar(255) DEFAULT NULL,
|
|
|
63 |
`pd_lien` varchar(255) DEFAULT NULL,
|
|
|
64 |
`pd_pere` int(10) unsigned NOT NULL DEFAULT '0',
|
|
|
65 |
`pd_permissions` smallint(5) unsigned DEFAULT NULL,
|
|
|
66 |
`pd_date_de_mise_a_jour` date DEFAULT NULL,
|
|
|
67 |
`pd_description` text,
|
|
|
68 |
`pd_visibilite` varchar(64) NOT NULL DEFAULT '',
|
|
|
69 |
PRIMARY KEY (`pd_id`),
|
|
|
70 |
KEY `pd_ce_projet` (`pd_ce_projet`),
|
|
|
71 |
KEY `pd_date_de_mise_a_jour` (`pd_date_de_mise_a_jour`)
|
|
|
72 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
73 |
|
|
|
74 |
-- --------------------------------------------------------
|
|
|
75 |
|
|
|
76 |
--
|
|
|
77 |
-- Structure de la table `projet_documents_sauvegarde`
|
|
|
78 |
--
|
|
|
79 |
|
|
|
80 |
CREATE TABLE IF NOT EXISTS `projet_documents_sauvegarde` (
|
|
|
81 |
`pd_id` int(10) unsigned NOT NULL DEFAULT '0',
|
|
|
82 |
`pd_ce_projet` int(10) unsigned NOT NULL DEFAULT '0',
|
|
|
83 |
`pd_ce_utilisateur` int(11) DEFAULT '0',
|
|
|
84 |
`pd_ce_type` int(11) NOT NULL DEFAULT '0',
|
|
|
85 |
`pd_nom` varchar(255) DEFAULT NULL,
|
|
|
86 |
`pd_lien` varchar(255) DEFAULT NULL,
|
|
|
87 |
`pd_pere` int(10) unsigned NOT NULL DEFAULT '0',
|
|
|
88 |
`pd_permissions` smallint(5) unsigned DEFAULT NULL,
|
|
|
89 |
`pd_date_de_mise_a_jour` date DEFAULT NULL,
|
|
|
90 |
`pd_description` text,
|
|
|
91 |
`pd_visibilite` varchar(64) NOT NULL DEFAULT '',
|
|
|
92 |
PRIMARY KEY (`pd_id`)
|
|
|
93 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
94 |
|
|
|
95 |
-- --------------------------------------------------------
|
|
|
96 |
|
|
|
97 |
--
|
|
|
98 |
-- Structure de la table `projet_evenement`
|
|
|
99 |
--
|
|
|
100 |
|
|
|
101 |
CREATE TABLE IF NOT EXISTS `projet_evenement` (
|
|
|
102 |
`pe_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
|
103 |
`pe_ce_utilisateur` int(11) NOT NULL DEFAULT '0',
|
|
|
104 |
`pe_ce_projet` int(10) unsigned NOT NULL DEFAULT '0',
|
|
|
105 |
`pe_date_debut` date DEFAULT NULL,
|
|
|
106 |
`pe_titre` varchar(255) DEFAULT NULL,
|
|
|
107 |
`pe_description` text,
|
|
|
108 |
`pe_date_fin` date DEFAULT NULL,
|
|
|
109 |
PRIMARY KEY (`pe_id`)
|
|
|
110 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
|
|
111 |
|
|
|
112 |
-- --------------------------------------------------------
|
|
|
113 |
|
|
|
114 |
--
|
|
|
115 |
-- Structure de la table `projet_hierarchie`
|
|
|
116 |
--
|
|
|
117 |
|
|
|
118 |
CREATE TABLE IF NOT EXISTS `projet_hierarchie` (
|
|
|
119 |
`ph_id_projet_pere` int(10) unsigned NOT NULL DEFAULT '0',
|
|
|
120 |
`ph_id_projet_fils` int(10) unsigned NOT NULL DEFAULT '0',
|
|
|
121 |
PRIMARY KEY (`ph_id_projet_pere`,`ph_id_projet_fils`)
|
|
|
122 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
123 |
|
|
|
124 |
-- --------------------------------------------------------
|
|
|
125 |
|
|
|
126 |
--
|
|
|
127 |
-- Structure de la table `projet_inscription_liste`
|
|
|
128 |
--
|
|
|
129 |
|
|
|
130 |
CREATE TABLE IF NOT EXISTS `projet_inscription_liste` (
|
|
|
131 |
`pil_id_liste` int(10) unsigned NOT NULL DEFAULT '0',
|
|
|
132 |
`pil_id_utilisateur` int(10) unsigned NOT NULL DEFAULT '0',
|
|
|
133 |
`pil_id_statut` tinyint(3) unsigned NOT NULL DEFAULT '0',
|
|
|
134 |
`pil_date_inscription` date NOT NULL,
|
|
|
135 |
PRIMARY KEY (`pil_id_liste`,`pil_id_utilisateur`)
|
|
|
136 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
137 |
|
|
|
138 |
-- --------------------------------------------------------
|
|
|
139 |
|
|
|
140 |
--
|
|
|
141 |
-- Structure de la table `projet_lien_forum`
|
|
|
142 |
--
|
|
|
143 |
|
|
|
144 |
CREATE TABLE IF NOT EXISTS `projet_lien_forum` (
|
|
|
145 |
`PLF_ID_PROJET` int(10) unsigned NOT NULL DEFAULT '0',
|
|
|
146 |
`PLF_ID_FORUM` int(10) unsigned NOT NULL DEFAULT '0',
|
|
|
147 |
PRIMARY KEY (`PLF_ID_PROJET`,`PLF_ID_FORUM`)
|
|
|
148 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Table des qui relie les forums et les projets';
|
|
|
149 |
|
|
|
150 |
-- --------------------------------------------------------
|
|
|
151 |
|
|
|
152 |
--
|
|
|
153 |
-- Structure de la table `projet_lien_liste`
|
|
|
154 |
--
|
|
|
155 |
|
|
|
156 |
CREATE TABLE IF NOT EXISTS `projet_lien_liste` (
|
|
|
157 |
`pl_id_liste` int(10) unsigned NOT NULL DEFAULT '0',
|
|
|
158 |
`pl_id_projet` int(10) unsigned NOT NULL DEFAULT '0',
|
|
|
159 |
PRIMARY KEY (`pl_id_liste`,`pl_id_projet`),
|
|
|
160 |
KEY `pl_id_projet` (`pl_id_projet`)
|
|
|
161 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='table faisant le lien entre les projets et les listes de dis';
|
|
|
162 |
|
|
|
163 |
-- --------------------------------------------------------
|
|
|
164 |
|
|
|
165 |
--
|
|
|
166 |
-- Structure de la table `projet_lien_liste_externe`
|
|
|
167 |
--
|
|
|
168 |
|
|
|
169 |
CREATE TABLE IF NOT EXISTS `projet_lien_liste_externe` (
|
|
|
170 |
`plle_id_projet` int(10) unsigned NOT NULL DEFAULT '0',
|
|
|
171 |
`plle_id_liste` int(10) unsigned NOT NULL DEFAULT '0',
|
|
|
172 |
PRIMARY KEY (`plle_id_projet`,`plle_id_liste`),
|
|
|
173 |
KEY `plle_id_projet` (`plle_id_projet`)
|
|
|
174 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
175 |
|
|
|
176 |
-- --------------------------------------------------------
|
|
|
177 |
|
|
|
178 |
--
|
|
|
179 |
-- Structure de la table `projet_liste`
|
|
|
180 |
--
|
|
|
181 |
|
|
|
182 |
CREATE TABLE IF NOT EXISTS `projet_liste` (
|
|
|
183 |
`pl_id_liste` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
|
184 |
`pl_nom_liste` varchar(255) NOT NULL DEFAULT '',
|
|
|
185 |
`pl_domaine` varchar(255) NOT NULL DEFAULT '',
|
|
|
186 |
`pl_adresse_liste` varchar(255) DEFAULT NULL,
|
|
|
187 |
`pl_adresse_inscription` varchar(255) DEFAULT NULL,
|
|
|
188 |
`pl_adresse_desinscription` varchar(255) DEFAULT NULL,
|
|
|
189 |
`pl_adresse_aide` varchar(255) DEFAULT NULL,
|
|
|
190 |
`pl_visibilite` tinyint(3) unsigned NOT NULL DEFAULT '0',
|
|
|
191 |
PRIMARY KEY (`pl_id_liste`)
|
|
|
192 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=70 ;
|
|
|
193 |
|
|
|
194 |
-- --------------------------------------------------------
|
|
|
195 |
|
|
|
196 |
--
|
|
|
197 |
-- Structure de la table `projet_liste_statut`
|
|
|
198 |
--
|
|
|
199 |
|
|
|
200 |
CREATE TABLE IF NOT EXISTS `projet_liste_statut` (
|
|
|
201 |
`pls_id_statut` tinyint(3) unsigned NOT NULL DEFAULT '0',
|
|
|
202 |
`pls_statut_nom` varchar(255) NOT NULL DEFAULT '',
|
|
|
203 |
PRIMARY KEY (`pls_id_statut`)
|
|
|
204 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
205 |
|
|
|
206 |
-- --------------------------------------------------------
|
|
|
207 |
|
|
|
208 |
--
|
|
|
209 |
-- Structure de la table `projet_preferences_utilisateurs`
|
|
|
210 |
--
|
|
|
211 |
|
|
|
212 |
CREATE TABLE IF NOT EXISTS `projet_preferences_utilisateurs` (
|
|
|
213 |
`ppu_id` int(10) unsigned DEFAULT NULL,
|
|
|
214 |
`ppu_ce_utilisateur` int(11) NOT NULL,
|
|
|
215 |
`ppu_preferences` text
|
|
|
216 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
217 |
|
|
|
218 |
-- --------------------------------------------------------
|
|
|
219 |
|
|
|
220 |
--
|
|
|
221 |
-- Structure de la table `projet_statistiques`
|
|
|
222 |
--
|
|
|
223 |
|
|
|
224 |
CREATE TABLE IF NOT EXISTS `projet_statistiques` (
|
|
|
225 |
`ps_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
|
226 |
`ps_ce_projet` int(10) unsigned NOT NULL,
|
|
|
227 |
`ps_msg_derniere_semaine` int(10) unsigned DEFAULT NULL,
|
|
|
228 |
`ps_doc_derniere_semaine` int(10) unsigned DEFAULT NULL,
|
|
|
229 |
`ps_nombre_inscrit_derniere_semaine` int(11) NOT NULL,
|
|
|
230 |
`ps_nombre_inscrit` int(10) unsigned DEFAULT NULL,
|
|
|
231 |
`ps_nombre_inscrit_liste` int(10) unsigned DEFAULT NULL,
|
|
|
232 |
`ps_nombre_membre_yahoo` int(10) unsigned NOT NULL,
|
|
|
233 |
`ps_modifwiki_derniere_semaine` int(10) unsigned DEFAULT NULL,
|
|
|
234 |
`ps_date` datetime NOT NULL,
|
|
|
235 |
`ps_maj` datetime NOT NULL,
|
|
|
236 |
`ps_somme` float unsigned NOT NULL,
|
|
|
237 |
`ps_pourcent` tinyint(3) unsigned NOT NULL,
|
|
|
238 |
`ps_dernier` tinyint(3) unsigned NOT NULL,
|
|
|
239 |
PRIMARY KEY (`ps_id`),
|
|
|
240 |
KEY `ps_date` (`ps_date`),
|
|
|
241 |
KEY `ps_ce_projet` (`ps_ce_projet`)
|
|
|
242 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6908 ;
|
|
|
243 |
|
|
|
244 |
-- --------------------------------------------------------
|
|
|
245 |
|
|
|
246 |
--
|
|
|
247 |
-- Structure de la table `projet_statut`
|
|
|
248 |
--
|
|
|
249 |
|
|
|
250 |
CREATE TABLE IF NOT EXISTS `projet_statut` (
|
|
|
251 |
`ps_id_statut` int(10) unsigned NOT NULL DEFAULT '0',
|
|
|
252 |
`ps_statut_nom` varchar(255) NOT NULL DEFAULT '',
|
|
|
253 |
PRIMARY KEY (`ps_id_statut`)
|
|
|
254 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
255 |
|
|
|
256 |
-- --------------------------------------------------------
|
|
|
257 |
|
|
|
258 |
--
|
|
|
259 |
-- Structure de la table `projet_statut_utilisateurs`
|
|
|
260 |
--
|
|
|
261 |
|
|
|
262 |
CREATE TABLE IF NOT EXISTS `projet_statut_utilisateurs` (
|
|
|
263 |
`psu_id_statut` int(10) unsigned NOT NULL DEFAULT '0',
|
|
|
264 |
`psu_id_utilisateur` int(11) NOT NULL DEFAULT '0',
|
|
|
265 |
`psu_id_projet` int(10) unsigned NOT NULL DEFAULT '0',
|
|
|
266 |
`psu_date_inscription` date DEFAULT '0000-00-00',
|
|
|
267 |
PRIMARY KEY (`psu_id_statut`,`psu_id_utilisateur`,`psu_id_projet`),
|
|
|
268 |
KEY `psu_id_projet` (`psu_id_projet`)
|
|
|
269 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
270 |
|
|
|
271 |
-- --------------------------------------------------------
|
|
|
272 |
|
|
|
273 |
--
|
|
|
274 |
-- Structure de la table `projet_template`
|
|
|
275 |
--
|
|
|
276 |
|
|
|
277 |
CREATE TABLE IF NOT EXISTS `projet_template` (
|
|
|
278 |
`pt_id_template` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
|
279 |
`pt_i18n` varchar(5) NOT NULL DEFAULT '',
|
|
|
280 |
`pt_template` text NOT NULL,
|
|
|
281 |
PRIMARY KEY (`pt_id_template`)
|
|
|
282 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
283 |
|
|
|
284 |
-- --------------------------------------------------------
|
|
|
285 |
|
|
|
286 |
--
|
|
|
287 |
-- Structure de la table `projet_theme`
|
|
|
288 |
--
|
|
|
289 |
|
|
|
290 |
CREATE TABLE IF NOT EXISTS `projet_theme` (
|
|
|
291 |
`pt_id_theme` tinyint(3) unsigned NOT NULL DEFAULT '0',
|
|
|
292 |
`pt_label_theme` varchar(255) NOT NULL,
|
|
|
293 |
PRIMARY KEY (`pt_id_theme`)
|
|
|
294 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
295 |
|
|
|
296 |
-- --------------------------------------------------------
|
|
|
297 |
|
|
|
298 |
--
|
|
|
299 |
-- Structure de la table `projet_type`
|
|
|
300 |
--
|
|
|
301 |
|
|
|
302 |
CREATE TABLE IF NOT EXISTS `projet_type` (
|
|
|
303 |
`pt_id_type` tinyint(3) unsigned NOT NULL DEFAULT '0',
|
|
|
304 |
`pt_label_type` varchar(255) NOT NULL DEFAULT '',
|
|
|
305 |
PRIMARY KEY (`pt_id_type`)
|
|
|
306 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|