Mise en route du suivi.
[aidenligne_francais_universite.git] / ecrire / base / serial.php
1 <?php
2
3 /***************************************************************************\
4 * SPIP, Systeme de publication pour l'internet *
5 * *
6 * Copyright (c) 2001-2007 *
7 * Arnaud Martin, Antoine Pitrou, Philippe Riviere, Emmanuel Saint-James *
8 * *
9 * Ce programme est un logiciel libre distribue sous licence GNU/GPL. *
10 * Pour plus de details voir le fichier COPYING.txt ou l'aide en ligne. *
11 \***************************************************************************/
12
13
14 if (!defined("_ECRIRE_INC_VERSION")) return;
15
16
17 $spip_articles = array(
18 "id_article" => "bigint(21) NOT NULL",
19 "surtitre" => "text NOT NULL",
20 "titre" => "text NOT NULL",
21 "soustitre" => "text NOT NULL",
22 "id_rubrique" => "bigint(21) DEFAULT '0' NOT NULL",
23 "descriptif" => "text NOT NULL",
24 "chapo" => "mediumtext NOT NULL",
25 "texte" => "longblob NOT NULL",
26 "ps" => "mediumtext NOT NULL",
27 "date" => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
28 "statut" => "varchar(10) DEFAULT '0' NOT NULL",
29 "id_secteur" => "bigint(21) DEFAULT '0' NOT NULL",
30 "maj" => "TIMESTAMP",
31 "export" => "VARCHAR(10) DEFAULT 'oui'",
32 "date_redac" => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
33 "visites" => "INTEGER DEFAULT '0' NOT NULL",
34 "referers" => "INTEGER DEFAULT '0' NOT NULL",
35 "popularite" => "DOUBLE DEFAULT '0' NOT NULL",
36 "accepter_forum" => "CHAR(3) NOT NULL",
37 "date_modif" => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
38 "lang" => "VARCHAR(10) DEFAULT '' NOT NULL",
39 "langue_choisie" => "VARCHAR(3) DEFAULT 'non'",
40 "id_trad" => "bigint(21) DEFAULT '0' NOT NULL",
41 "extra" => "longblob NULL",
42 "idx" => "ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL",
43 "id_version" => "int unsigned DEFAULT '0' NOT NULL",
44 "nom_site" => "tinytext NOT NULL",
45 "url_site" => "VARCHAR(255) NOT NULL",
46 "url_propre" => "VARCHAR(255) NOT NULL");
47
48 $spip_articles_key = array(
49 "PRIMARY KEY" => "id_article",
50 "KEY id_rubrique" => "id_rubrique",
51 "KEY id_secteur" => "id_secteur",
52 "KEY id_trad" => "id_trad",
53 "KEY lang" => "lang",
54 "KEY statut" => "statut, date",
55 "KEY url_site" => "url_site",
56 "KEY date_modif" => "date_modif",
57 "KEY idx" => "idx",
58 "KEY url_propre" => "url_propre");
59
60 $spip_auteurs = array(
61 "id_auteur" => "bigint(21) NOT NULL",
62 "nom" => "text NOT NULL",
63 "bio" => "text NOT NULL",
64 "email" => "tinytext NOT NULL",
65 "nom_site" => "tinytext NOT NULL",
66 "url_site" => "text NOT NULL",
67 "login" => "VARCHAR(255) BINARY NOT NULL",
68 "pass" => "tinytext NOT NULL",
69 "low_sec" => "tinytext NOT NULL",
70 "statut" => "VARCHAR(255) NOT NULL",
71 "maj" => "TIMESTAMP",
72 "pgp" => "BLOB NOT NULL",
73 "htpass" => "tinyblob NOT NULL",
74 "en_ligne" => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
75 "imessage" => "VARCHAR(3) NOT NULL",
76 "messagerie" => "VARCHAR(3) NOT NULL",
77 "alea_actuel" => "tinytext NOT NULL",
78 "alea_futur" => "tinytext NOT NULL",
79 "prefs" => "tinytext NOT NULL",
80 "cookie_oubli" => "tinytext NOT NULL",
81 "source" => "VARCHAR(10) DEFAULT 'spip' NOT NULL",
82 "lang" => "VARCHAR(10) DEFAULT '' NOT NULL",
83 "idx" => "ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL",
84 "url_propre" => "VARCHAR(255) NOT NULL",
85 "extra" => "longblob NULL");
86
87 $spip_auteurs_key = array(
88 "PRIMARY KEY" => "id_auteur",
89 "KEY login" => "login",
90 "KEY statut" => "statut",
91 "KEY lang" => "lang",
92 "KEY idx" => "idx",
93 "KEY en_ligne" => "en_ligne",
94 "KEY url_propre" => "url_propre");
95
96 $spip_breves = array(
97 "id_breve" => "bigint(21) NOT NULL",
98 "date_heure" => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
99 "titre" => "text NOT NULL",
100 "texte" => "longblob NOT NULL",
101 "lien_titre" => "text NOT NULL",
102 "lien_url" => "text NOT NULL",
103 "statut" => "varchar(6) NOT NULL",
104 "id_rubrique" => "bigint(21) DEFAULT '0' NOT NULL",
105 "lang" => "VARCHAR(10) DEFAULT '' NOT NULL",
106 "langue_choisie" => "VARCHAR(3) DEFAULT 'non'",
107 "maj" => "TIMESTAMP",
108 "idx" => "ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL",
109 "extra" => "longblob NULL",
110 "url_propre" => "VARCHAR(255) NOT NULL");
111
112 $spip_breves_key = array(
113 "PRIMARY KEY" => "id_breve",
114 "KEY idx" => "idx",
115 "KEY id_rubrique" => "id_rubrique",
116 "KEY url_propre" => "url_propre");
117
118 $spip_messages = array(
119 "id_message" => "bigint(21) NOT NULL",
120 "titre" => "text NOT NULL",
121 "texte" => "longblob NOT NULL",
122 "type" => "varchar(6) NOT NULL",
123 "date_heure" => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
124 "date_fin" => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
125 "rv" => "varchar(3) NOT NULL",
126 "statut" => "varchar(6) NOT NULL",
127 "id_auteur" => "bigint(21) NOT NULL",
128 "maj" => "TIMESTAMP");
129
130 $spip_messages_key = array(
131 "PRIMARY KEY" => "id_message",
132 "KEY id_auteur" => "id_auteur");
133
134 $spip_mots = array(
135 "id_mot" => "bigint(21) NOT NULL",
136 "titre" => "text NOT NULL",
137 "descriptif" => "text NOT NULL",
138 "texte" => "longblob NOT NULL",
139 "id_groupe" => "bigint(21) NOT NULL",
140 "type" => "text NOT NULL",
141 "extra" => "longblob NULL",
142 "idx" => "ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL",
143 "url_propre" => "VARCHAR(255) NOT NULL",
144 "maj" => "TIMESTAMP");
145
146 $spip_mots_key = array(
147 "PRIMARY KEY" => "id_mot",
148 "KEY idx" => "idx",
149 "KEY url_propre" => "url_propre");
150
151 $spip_groupes_mots = array(
152 "id_groupe" => "bigint(21) NOT NULL",
153 "titre" => "text NOT NULL",
154 "descriptif" => "text NOT NULL",
155 "texte" => "longblob NOT NULL",
156 "unseul" => "varchar(3) NOT NULL",
157 "obligatoire" => "varchar(3) NOT NULL",
158 "articles" => "varchar(3) NOT NULL",
159 "breves" => "varchar(3) NOT NULL",
160 "rubriques" => "varchar(3) NOT NULL",
161 "syndic" => "varchar(3) NOT NULL",
162 "minirezo" => "varchar(3) NOT NULL",
163 "comite" => "varchar(3) NOT NULL",
164 "forum" => "varchar(3) NOT NULL",
165 "maj" => "TIMESTAMP");
166
167 $spip_groupes_mots_key = array(
168 "PRIMARY KEY" => "id_groupe");
169
170 $spip_rubriques = array(
171 "id_rubrique" => "bigint(21) NOT NULL",
172 "id_parent" => "bigint(21) DEFAULT '0' NOT NULL",
173 "titre" => "text NOT NULL",
174 "descriptif" => "text NOT NULL",
175 "texte" => "longblob NOT NULL",
176 "id_secteur" => "bigint(21) DEFAULT '0' NOT NULL",
177 "maj" => "TIMESTAMP",
178 "export" => "VARCHAR(10) DEFAULT 'oui'",
179 "id_import" => "BIGINT DEFAULT '0'",
180 "statut" => "VARCHAR(10) NOT NULL",
181 "date" => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
182 "lang" => "VARCHAR(10) DEFAULT '' NOT NULL",
183 "langue_choisie" => "VARCHAR(3) DEFAULT 'non'",
184 "idx" => "ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL",
185 "extra" => "longblob NULL",
186 "url_propre" => "VARCHAR(255) NOT NULL",
187 "statut_tmp" => "VARCHAR(10) NOT NULL",
188 "date_tmp" => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL"
189 );
190
191 $spip_rubriques_key = array(
192 "PRIMARY KEY" => "id_rubrique",
193 "KEY lang" => "lang",
194 "KEY idx" => "idx",
195 "KEY id_parent" => "id_parent",
196 "KEY url_propre" => "url_propre");
197
198 $spip_documents = array(
199 "id_document" => "bigint(21) NOT NULL",
200 "id_vignette" => "bigint(21) DEFAULT '0' NOT NULL",
201 "id_type" => "bigint(21) DEFAULT '0' NOT NULL",
202 "titre" => "text NOT NULL",
203 "date" => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
204 "descriptif" => "text NOT NULL",
205 "fichier" => "varchar(255) NOT NULL",
206 "taille" => "integer NOT NULL",
207 "largeur" => "integer NOT NULL",
208 "hauteur" => "integer NOT NULL",
209 "mode" => "ENUM('vignette', 'document') NOT NULL",
210 "distant" => "VARCHAR(3) DEFAULT 'non'",
211 "idx" => "ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL",
212 "maj" => "TIMESTAMP");
213
214 $spip_documents_key = array(
215 "PRIMARY KEY" => "id_document",
216 "KEY id_vignette" => "id_vignette",
217 "KEY mode" => "mode",
218 "KEY id_type" => "id_type");
219
220 $spip_types_documents = array(
221 "id_type" => "bigint(21) NOT NULL",
222 "titre" => "text NOT NULL",
223 "descriptif" => "text NOT NULL",
224 "extension" => "varchar(10) NOT NULL",
225 "mime_type" => "varchar(100) NOT NULL",
226 "inclus" => "ENUM('non', 'image', 'embed') NOT NULL DEFAULT 'non'",
227 "upload" => "ENUM('oui', 'non') NOT NULL DEFAULT 'oui'",
228 "maj" => "TIMESTAMP");
229
230 $spip_types_documents_key = array(
231 "PRIMARY KEY" => "id_type",
232 "UNIQUE extension" => "extension",
233 "KEY inclus" => "inclus");
234
235 $spip_syndic = array(
236 "id_syndic" => "bigint(21) NOT NULL",
237 "id_rubrique" => "bigint(21) DEFAULT '0' NOT NULL",
238 "id_secteur" => "bigint(21) DEFAULT '0' NOT NULL",
239 "nom_site" => "blob NOT NULL",
240 "url_site" => "blob NOT NULL",
241 "url_syndic" => "blob NOT NULL",
242 "descriptif" => "blob NOT NULL",
243 "url_propre" => "VARCHAR(255) NOT NULL",
244 "idx" => "ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL",
245 "maj" => "TIMESTAMP",
246 "syndication" => "VARCHAR(3) NOT NULL",
247 "statut" => "VARCHAR(10) NOT NULL",
248 "date" => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
249 "date_syndic" => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
250 "date_index" => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
251 "extra" => "longblob NULL",
252 "moderation" => "VARCHAR(3) DEFAULT 'non'",
253 "miroir" => "VARCHAR(3) DEFAULT 'non'",
254 "oubli" => "VARCHAR(3) DEFAULT 'non'",
255 "resume" => "VARCHAR(3) DEFAULT 'oui'"
256 );
257
258 $spip_syndic_key = array(
259 "PRIMARY KEY" => "id_syndic",
260 "KEY id_rubrique" => "id_rubrique",
261 "KEY id_secteur" => "id_secteur",
262 "KEY idx" => "idx",
263 "KEY statut" => "statut, date_syndic",
264 "KEY url_propre" => "url_propre");
265
266 $spip_syndic_articles = array(
267 "id_syndic_article" => "bigint(21) NOT NULL",
268 "id_syndic" => "bigint(21) DEFAULT '0' NOT NULL",
269 "titre" => "text NOT NULL",
270 "url" => "VARCHAR(255) NOT NULL",
271 "date" => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
272 "lesauteurs" => "text NOT NULL",
273 "maj" => "TIMESTAMP",
274 "statut" => "VARCHAR(10) NOT NULL",
275 "descriptif" => "blob NOT NULL",
276 "lang" => "VARCHAR(10) DEFAULT '' NOT NULL",
277 "url_source" => "TINYTEXT DEFAULT '' NOT NULL",
278 "source" => "TINYTEXT DEFAULT '' NOT NULL",
279 "tags" => "TEXT DEFAULT '' NOT NULL");
280
281 $spip_syndic_articles_key = array(
282 "PRIMARY KEY" => "id_syndic_article",
283 "KEY id_syndic" => "id_syndic",
284 "KEY statut" => "statut",
285 "KEY url" => "url");
286
287 $spip_forum = array(
288 "id_forum" => "bigint(21) NOT NULL",
289 "id_parent" => "bigint(21) DEFAULT '0' NOT NULL",
290 "id_thread" => "bigint(21) DEFAULT '0' NOT NULL",
291 "id_rubrique" => "bigint(21) DEFAULT '0' NOT NULL",
292 "id_article" => "bigint(21) DEFAULT '0' NOT NULL",
293 "id_breve" => "bigint(21) DEFAULT '0' NOT NULL",
294 "date_heure" => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
295 "titre" => "text NOT NULL",
296 "texte" => "mediumtext NOT NULL",
297 "auteur" => "text NOT NULL",
298 "email_auteur" => "text NOT NULL",
299 "nom_site" => "text NOT NULL",
300 "url_site" => "text NOT NULL",
301 "statut" => "varchar(8) NOT NULL",
302 "idx" => "ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL",
303 "ip" => "varchar(16)",
304 "maj" => "TIMESTAMP",
305 "id_auteur" => "BIGINT DEFAULT '0' NOT NULL",
306 "id_message" => "bigint(21) DEFAULT '0' NOT NULL",
307 "id_syndic" => "bigint(21) DEFAULT '0' NOT NULL");
308
309 $spip_forum_key = array(
310 "PRIMARY KEY" => "id_forum",
311 "KEY id_parent" => "id_parent",
312 "KEY id_article" => "id_article",
313 "KEY id_breve" => "id_breve",
314 "KEY id_message" => "id_message",
315 "KEY id_syndic" => "id_syndic",
316 "KEY id_rubrique" => "id_rubrique",
317 "KEY idx" => "idx",
318 "KEY statut" => "statut, date_heure");
319
320 $spip_signatures = array(
321 "id_signature" => "bigint(21) NOT NULL",
322 "id_article" => "bigint(21) DEFAULT '0' NOT NULL",
323 "date_time" => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
324 "nom_email" => "text NOT NULL",
325 "ad_email" => "text NOT NULL",
326 "nom_site" => "text NOT NULL",
327 "url_site" => "text NOT NULL",
328 "message" => "mediumtext NOT NULL",
329 "statut" => "varchar(10) NOT NULL",
330 "idx" => "ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL",
331 "maj" => "TIMESTAMP");
332
333 $spip_signatures_key = array(
334 "PRIMARY KEY" => "id_signature",
335 "KEY id_article" => "id_article",
336 "KEY idx" => "idx",
337 "KEY statut" => "statut");
338
339
340 global $tables_principales;
341
342 /// Attention: mes_fonctions peut avoir deja defini cette variable
343 /// il faut donc rajouter, mais pas reinitialiser
344
345 $tables_principales['spip_articles'] =
346 array('field' => &$spip_articles, 'key' => &$spip_articles_key);
347 $tables_principales['spip_auteurs'] =
348 array('field' => &$spip_auteurs, 'key' => &$spip_auteurs_key);
349 $tables_principales['spip_breves'] =
350 array('field' => &$spip_breves, 'key' => &$spip_breves_key);
351 $tables_principales['spip_messages'] =
352 array('field' => &$spip_messages, 'key' => &$spip_messages_key);
353 $tables_principales['spip_mots'] =
354 array('field' => &$spip_mots, 'key' => &$spip_mots_key);
355 $tables_principales['spip_groupes_mots'] =
356 array('field' => &$spip_groupes_mots, 'key' => &$spip_groupes_mots_key);
357 $tables_principales['spip_rubriques'] =
358 array('field' => &$spip_rubriques, 'key' => &$spip_rubriques_key);
359 $tables_principales['spip_documents'] =
360 array('field' => &$spip_documents, 'key' => &$spip_documents_key);
361 $tables_principales['spip_types_documents'] =
362 array('field' => &$spip_types_documents, 'key' => &$spip_types_documents_key);
363 $tables_principales['spip_syndic'] =
364 array('field' => &$spip_syndic, 'key' => &$spip_syndic_key);
365 $tables_principales['spip_syndic_articles'] =
366 array('field' => &$spip_syndic_articles, 'key' => &$spip_syndic_articles_key);
367 $tables_principales['spip_forum'] =
368 array('field' => &$spip_forum, 'key' => &$spip_forum_key);
369 $tables_principales['spip_signatures'] =
370 array('field' => &$spip_signatures, 'key' => &$spip_signatures_key);
371
372 ?>