· 8 years ago · Dec 09, 2017, 10:22 AM
1-- MySQL dump 10.13 Distrib 5.6.35, for Linux (x86_64)
2--
3-- Host: localhost Database: lf2hyggr_spipfactory
4-- ------------------------------------------------------
5-- Server version 5.6.35-cll-lve
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `spip_articles`
20--
21
22DROP TABLE IF EXISTS `spip_articles`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `spip_articles` (
26 `id_article` bigint(21) NOT NULL AUTO_INCREMENT,
27 `surtitre` text NOT NULL,
28 `titre` text NOT NULL,
29 `soustitre` text NOT NULL,
30 `id_rubrique` bigint(21) NOT NULL DEFAULT '0',
31 `descriptif` text NOT NULL,
32 `chapo` mediumtext NOT NULL,
33 `texte` longtext NOT NULL,
34 `ps` mediumtext NOT NULL,
35 `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
36 `statut` varchar(10) NOT NULL DEFAULT '0',
37 `id_secteur` bigint(21) NOT NULL DEFAULT '0',
38 `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
39 `export` varchar(10) DEFAULT 'oui',
40 `date_redac` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
41 `visites` int(11) NOT NULL DEFAULT '0',
42 `referers` int(11) NOT NULL DEFAULT '0',
43 `popularite` double NOT NULL DEFAULT '0',
44 `accepter_forum` char(3) NOT NULL DEFAULT '',
45 `date_modif` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
46 `lang` varchar(10) NOT NULL DEFAULT '',
47 `langue_choisie` varchar(3) DEFAULT 'non',
48 `id_trad` bigint(21) NOT NULL DEFAULT '0',
49 `nom_site` tinytext NOT NULL,
50 `url_site` text NOT NULL,
51 `virtuel` text NOT NULL,
52 `id_licence` bigint(21) NOT NULL DEFAULT '0',
53 PRIMARY KEY (`id_article`),
54 KEY `id_rubrique` (`id_rubrique`),
55 KEY `id_secteur` (`id_secteur`),
56 KEY `id_trad` (`id_trad`),
57 KEY `lang` (`lang`),
58 KEY `statut` (`statut`,`date`)
59) ENGINE=MyISAM DEFAULT CHARSET=utf8;
60/*!40101 SET character_set_client = @saved_cs_client */;
61
62--
63-- Dumping data for table `spip_articles`
64--
65
66LOCK TABLES `spip_articles` WRITE;
67/*!40000 ALTER TABLE `spip_articles` DISABLE KEYS */;
68/*!40000 ALTER TABLE `spip_articles` ENABLE KEYS */;
69UNLOCK TABLES;
70
71--
72-- Table structure for table `spip_auteurs`
73--
74
75DROP TABLE IF EXISTS `spip_auteurs`;
76/*!40101 SET @saved_cs_client = @@character_set_client */;
77/*!40101 SET character_set_client = utf8 */;
78CREATE TABLE `spip_auteurs` (
79 `id_auteur` bigint(21) NOT NULL AUTO_INCREMENT,
80 `nom` text NOT NULL,
81 `bio` text NOT NULL,
82 `email` tinytext NOT NULL,
83 `nom_site` tinytext NOT NULL,
84 `url_site` text NOT NULL,
85 `login` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
86 `pass` tinytext NOT NULL,
87 `low_sec` tinytext NOT NULL,
88 `statut` varchar(255) NOT NULL DEFAULT '0',
89 `webmestre` varchar(3) NOT NULL DEFAULT 'non',
90 `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
91 `pgp` text NOT NULL,
92 `htpass` tinytext NOT NULL,
93 `en_ligne` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
94 `alea_actuel` tinytext,
95 `alea_futur` tinytext,
96 `prefs` text,
97 `cookie_oubli` tinytext,
98 `source` varchar(10) NOT NULL DEFAULT 'spip',
99 `lang` varchar(10) NOT NULL DEFAULT '',
100 `imessage` varchar(3) DEFAULT NULL,
101 `messagerie` varchar(3) DEFAULT NULL,
102 `input_1` text NOT NULL,
103 `input_2` text NOT NULL,
104 `input_3` text NOT NULL,
105 `input_4` text NOT NULL,
106 `input_5` text NOT NULL,
107 `input_6` text NOT NULL,
108 `textarea_1` text NOT NULL,
109 `input_7` text NOT NULL,
110 `oui_non_1` varchar(3) NOT NULL DEFAULT '',
111 `oui_non_2` varchar(3) NOT NULL DEFAULT '',
112 `oui_non_3` varchar(3) NOT NULL DEFAULT '',
113 `input_9` text NOT NULL,
114 `email_1` text NOT NULL,
115 `input_10` text NOT NULL,
116 `email_2` text NOT NULL,
117 `input_11` text NOT NULL,
118 `email_3` text NOT NULL,
119 `input_12` text NOT NULL,
120 `email_4` text NOT NULL,
121 `input_13` text NOT NULL,
122 `email_5` text NOT NULL,
123 `date_1` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
124 `textarea_2` text NOT NULL,
125 `oui_non_4` varchar(3) NOT NULL DEFAULT '',
126 `oui_non_5` varchar(3) NOT NULL DEFAULT '',
127 PRIMARY KEY (`id_auteur`),
128 KEY `login` (`login`),
129 KEY `statut` (`statut`),
130 KEY `en_ligne` (`en_ligne`)
131) ENGINE=MyISAM DEFAULT CHARSET=utf8;
132/*!40101 SET character_set_client = @saved_cs_client */;
133
134--
135-- Dumping data for table `spip_auteurs`
136--
137
138LOCK TABLES `spip_auteurs` WRITE;
139/*!40000 ALTER TABLE `spip_auteurs` DISABLE KEYS */;
140/*!40000 ALTER TABLE `spip_auteurs` ENABLE KEYS */;
141UNLOCK TABLES;
142
143--
144-- Table structure for table `spip_auteurs_liens`
145--
146
147DROP TABLE IF EXISTS `spip_auteurs_liens`;
148/*!40101 SET @saved_cs_client = @@character_set_client */;
149/*!40101 SET character_set_client = utf8 */;
150CREATE TABLE `spip_auteurs_liens` (
151 `id_auteur` bigint(21) NOT NULL DEFAULT '0',
152 `id_objet` bigint(21) NOT NULL DEFAULT '0',
153 `objet` varchar(25) NOT NULL DEFAULT '',
154 `vu` varchar(6) NOT NULL DEFAULT 'non',
155 PRIMARY KEY (`id_auteur`,`id_objet`,`objet`),
156 KEY `id_auteur` (`id_auteur`),
157 KEY `id_objet` (`id_objet`),
158 KEY `objet` (`objet`)
159) ENGINE=MyISAM DEFAULT CHARSET=utf8;
160/*!40101 SET character_set_client = @saved_cs_client */;
161
162--
163-- Dumping data for table `spip_auteurs_liens`
164--
165
166LOCK TABLES `spip_auteurs_liens` WRITE;
167/*!40000 ALTER TABLE `spip_auteurs_liens` DISABLE KEYS */;
168/*!40000 ALTER TABLE `spip_auteurs_liens` ENABLE KEYS */;
169UNLOCK TABLES;
170
171--
172-- Table structure for table `spip_breves`
173--
174
175DROP TABLE IF EXISTS `spip_breves`;
176/*!40101 SET @saved_cs_client = @@character_set_client */;
177/*!40101 SET character_set_client = utf8 */;
178CREATE TABLE `spip_breves` (
179 `id_breve` bigint(21) NOT NULL AUTO_INCREMENT,
180 `date_heure` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
181 `titre` text NOT NULL,
182 `texte` longtext NOT NULL,
183 `lien_titre` text NOT NULL,
184 `lien_url` text NOT NULL,
185 `statut` varchar(6) NOT NULL DEFAULT '0',
186 `id_rubrique` bigint(21) NOT NULL DEFAULT '0',
187 `lang` varchar(10) NOT NULL DEFAULT '',
188 `langue_choisie` varchar(3) DEFAULT 'non',
189 `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
190 PRIMARY KEY (`id_breve`),
191 KEY `id_rubrique` (`id_rubrique`)
192) ENGINE=MyISAM DEFAULT CHARSET=utf8;
193/*!40101 SET character_set_client = @saved_cs_client */;
194
195--
196-- Dumping data for table `spip_breves`
197--
198
199LOCK TABLES `spip_breves` WRITE;
200/*!40000 ALTER TABLE `spip_breves` DISABLE KEYS */;
201/*!40000 ALTER TABLE `spip_breves` ENABLE KEYS */;
202UNLOCK TABLES;
203
204--
205-- Table structure for table `spip_depots`
206--
207
208DROP TABLE IF EXISTS `spip_depots`;
209/*!40101 SET @saved_cs_client = @@character_set_client */;
210/*!40101 SET character_set_client = utf8 */;
211CREATE TABLE `spip_depots` (
212 `id_depot` bigint(21) NOT NULL AUTO_INCREMENT,
213 `titre` text NOT NULL,
214 `descriptif` text NOT NULL,
215 `type` varchar(10) NOT NULL DEFAULT '',
216 `url_serveur` varchar(255) NOT NULL DEFAULT '',
217 `url_brouteur` varchar(255) NOT NULL DEFAULT '',
218 `url_archives` varchar(255) NOT NULL DEFAULT '',
219 `url_commits` varchar(255) NOT NULL DEFAULT '',
220 `xml_paquets` varchar(255) NOT NULL DEFAULT '',
221 `sha_paquets` varchar(40) NOT NULL DEFAULT '',
222 `nbr_paquets` int(11) NOT NULL DEFAULT '0',
223 `nbr_plugins` int(11) NOT NULL DEFAULT '0',
224 `nbr_autres` int(11) NOT NULL DEFAULT '0',
225 `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
226 PRIMARY KEY (`id_depot`)
227) ENGINE=MyISAM DEFAULT CHARSET=utf8;
228/*!40101 SET character_set_client = @saved_cs_client */;
229
230--
231-- Dumping data for table `spip_depots`
232--
233
234LOCK TABLES `spip_depots` WRITE;
235/*!40000 ALTER TABLE `spip_depots` DISABLE KEYS */;
236/*!40000 ALTER TABLE `spip_depots` ENABLE KEYS */;
237UNLOCK TABLES;
238
239--
240-- Table structure for table `spip_depots_plugins`
241--
242
243DROP TABLE IF EXISTS `spip_depots_plugins`;
244/*!40101 SET @saved_cs_client = @@character_set_client */;
245/*!40101 SET character_set_client = utf8 */;
246CREATE TABLE `spip_depots_plugins` (
247 `id_depot` bigint(21) NOT NULL,
248 `id_plugin` bigint(21) NOT NULL,
249 PRIMARY KEY (`id_depot`,`id_plugin`)
250) ENGINE=MyISAM DEFAULT CHARSET=utf8;
251/*!40101 SET character_set_client = @saved_cs_client */;
252
253--
254-- Dumping data for table `spip_depots_plugins`
255--
256
257LOCK TABLES `spip_depots_plugins` WRITE;
258/*!40000 ALTER TABLE `spip_depots_plugins` DISABLE KEYS */;
259/*!40000 ALTER TABLE `spip_depots_plugins` ENABLE KEYS */;
260UNLOCK TABLES;
261
262--
263-- Table structure for table `spip_documents`
264--
265
266DROP TABLE IF EXISTS `spip_documents`;
267/*!40101 SET @saved_cs_client = @@character_set_client */;
268/*!40101 SET character_set_client = utf8 */;
269CREATE TABLE `spip_documents` (
270 `id_document` bigint(21) NOT NULL AUTO_INCREMENT,
271 `id_vignette` bigint(21) NOT NULL DEFAULT '0',
272 `extension` varchar(10) NOT NULL DEFAULT '',
273 `titre` text NOT NULL,
274 `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
275 `descriptif` text NOT NULL,
276 `fichier` text NOT NULL,
277 `taille` bigint(20) DEFAULT NULL,
278 `largeur` int(11) DEFAULT NULL,
279 `hauteur` int(11) DEFAULT NULL,
280 `duree` int(11) DEFAULT NULL,
281 `media` varchar(10) NOT NULL DEFAULT 'file',
282 `mode` varchar(10) NOT NULL DEFAULT 'document',
283 `distant` varchar(3) DEFAULT 'non',
284 `statut` varchar(10) NOT NULL DEFAULT '0',
285 `credits` text NOT NULL,
286 `date_publication` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
287 `brise` tinyint(4) DEFAULT '0',
288 `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
289 `id_licence` bigint(21) NOT NULL DEFAULT '0',
290 PRIMARY KEY (`id_document`),
291 KEY `id_vignette` (`id_vignette`),
292 KEY `mode` (`mode`),
293 KEY `extension` (`extension`)
294) ENGINE=MyISAM DEFAULT CHARSET=utf8;
295/*!40101 SET character_set_client = @saved_cs_client */;
296
297--
298-- Dumping data for table `spip_documents`
299--
300
301LOCK TABLES `spip_documents` WRITE;
302/*!40000 ALTER TABLE `spip_documents` DISABLE KEYS */;
303/*!40000 ALTER TABLE `spip_documents` ENABLE KEYS */;
304UNLOCK TABLES;
305
306--
307-- Table structure for table `spip_documents_liens`
308--
309
310DROP TABLE IF EXISTS `spip_documents_liens`;
311/*!40101 SET @saved_cs_client = @@character_set_client */;
312/*!40101 SET character_set_client = utf8 */;
313CREATE TABLE `spip_documents_liens` (
314 `id_document` bigint(21) NOT NULL DEFAULT '0',
315 `id_objet` bigint(21) NOT NULL DEFAULT '0',
316 `objet` varchar(25) NOT NULL DEFAULT '',
317 `vu` enum('non','oui') NOT NULL DEFAULT 'non',
318 `rang_lien` int(4) NOT NULL DEFAULT '0',
319 PRIMARY KEY (`id_document`,`id_objet`,`objet`),
320 KEY `id_document` (`id_document`),
321 KEY `id_objet` (`id_objet`),
322 KEY `objet` (`objet`)
323) ENGINE=MyISAM DEFAULT CHARSET=utf8;
324/*!40101 SET character_set_client = @saved_cs_client */;
325
326--
327-- Dumping data for table `spip_documents_liens`
328--
329
330LOCK TABLES `spip_documents_liens` WRITE;
331/*!40000 ALTER TABLE `spip_documents_liens` DISABLE KEYS */;
332/*!40000 ALTER TABLE `spip_documents_liens` ENABLE KEYS */;
333UNLOCK TABLES;
334
335--
336-- Table structure for table `spip_evenements`
337--
338
339DROP TABLE IF EXISTS `spip_evenements`;
340/*!40101 SET @saved_cs_client = @@character_set_client */;
341/*!40101 SET character_set_client = utf8 */;
342CREATE TABLE `spip_evenements` (
343 `id_evenement` bigint(21) NOT NULL AUTO_INCREMENT,
344 `id_article` bigint(21) NOT NULL DEFAULT '0',
345 `date_debut` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
346 `date_fin` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
347 `titre` text NOT NULL,
348 `descriptif` text NOT NULL,
349 `lieu` text NOT NULL,
350 `adresse` text NOT NULL,
351 `inscription` tinyint(1) NOT NULL DEFAULT '0',
352 `places` int(11) NOT NULL DEFAULT '0',
353 `horaire` varchar(3) NOT NULL DEFAULT 'oui',
354 `id_evenement_source` bigint(21) NOT NULL,
355 `statut` varchar(10) NOT NULL DEFAULT '0',
356 `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
357 `date_creation` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
358 PRIMARY KEY (`id_evenement`),
359 KEY `date_debut` (`date_debut`),
360 KEY `date_fin` (`date_fin`),
361 KEY `id_article` (`id_article`)
362) ENGINE=MyISAM DEFAULT CHARSET=utf8;
363/*!40101 SET character_set_client = @saved_cs_client */;
364
365--
366-- Dumping data for table `spip_evenements`
367--
368
369LOCK TABLES `spip_evenements` WRITE;
370/*!40000 ALTER TABLE `spip_evenements` DISABLE KEYS */;
371/*!40000 ALTER TABLE `spip_evenements` ENABLE KEYS */;
372UNLOCK TABLES;
373
374--
375-- Table structure for table `spip_evenements_participants`
376--
377
378DROP TABLE IF EXISTS `spip_evenements_participants`;
379/*!40101 SET @saved_cs_client = @@character_set_client */;
380/*!40101 SET character_set_client = utf8 */;
381CREATE TABLE `spip_evenements_participants` (
382 `id_evenement_participant` bigint(21) NOT NULL AUTO_INCREMENT,
383 `id_evenement` bigint(21) NOT NULL DEFAULT '0',
384 `id_auteur` bigint(21) NOT NULL DEFAULT '0',
385 `nom` text NOT NULL,
386 `email` tinytext NOT NULL,
387 `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
388 `reponse` char(3) NOT NULL DEFAULT '?',
389 PRIMARY KEY (`id_evenement_participant`),
390 KEY `id_evenement` (`id_evenement`),
391 KEY `id_auteur` (`id_auteur`)
392) ENGINE=MyISAM DEFAULT CHARSET=utf8;
393/*!40101 SET character_set_client = @saved_cs_client */;
394
395--
396-- Dumping data for table `spip_evenements_participants`
397--
398
399LOCK TABLES `spip_evenements_participants` WRITE;
400/*!40000 ALTER TABLE `spip_evenements_participants` DISABLE KEYS */;
401/*!40000 ALTER TABLE `spip_evenements_participants` ENABLE KEYS */;
402UNLOCK TABLES;
403
404--
405-- Table structure for table `spip_formulaires`
406--
407
408DROP TABLE IF EXISTS `spip_formulaires`;
409/*!40101 SET @saved_cs_client = @@character_set_client */;
410/*!40101 SET character_set_client = utf8 */;
411CREATE TABLE `spip_formulaires` (
412 `id_formulaire` bigint(21) NOT NULL AUTO_INCREMENT,
413 `identifiant` varchar(200) DEFAULT NULL,
414 `titre` text NOT NULL,
415 `descriptif` text,
416 `css` varchar(255) NOT NULL DEFAULT '',
417 `message_retour` text NOT NULL,
418 `saisies` longtext NOT NULL,
419 `traitements` text NOT NULL,
420 `public` enum('non','oui') NOT NULL DEFAULT 'non',
421 `apres` varchar(12) NOT NULL DEFAULT '',
422 `unicite` text NOT NULL,
423 `message_erreur_unicite` text NOT NULL,
424 `url_redirect` varchar(255) DEFAULT NULL,
425 `statut` varchar(10) NOT NULL DEFAULT '',
426 `resume_reponse` text NOT NULL,
427 `date_creation` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
428 `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
429 PRIMARY KEY (`id_formulaire`)
430) ENGINE=MyISAM DEFAULT CHARSET=utf8;
431/*!40101 SET character_set_client = @saved_cs_client */;
432
433--
434-- Dumping data for table `spip_formulaires`
435--
436
437LOCK TABLES `spip_formulaires` WRITE;
438/*!40000 ALTER TABLE `spip_formulaires` DISABLE KEYS */;
439/*!40000 ALTER TABLE `spip_formulaires` ENABLE KEYS */;
440UNLOCK TABLES;
441
442--
443-- Table structure for table `spip_formulaires_liens`
444--
445
446DROP TABLE IF EXISTS `spip_formulaires_liens`;
447/*!40101 SET @saved_cs_client = @@character_set_client */;
448/*!40101 SET character_set_client = utf8 */;
449CREATE TABLE `spip_formulaires_liens` (
450 `id_formulaire` bigint(21) NOT NULL DEFAULT '0',
451 `id_objet` bigint(21) NOT NULL DEFAULT '0',
452 `objet` varchar(25) NOT NULL DEFAULT '',
453 PRIMARY KEY (`id_formulaire`,`id_objet`,`objet`),
454 KEY `id_formulaire` (`id_formulaire`)
455) ENGINE=MyISAM DEFAULT CHARSET=utf8;
456/*!40101 SET character_set_client = @saved_cs_client */;
457
458--
459-- Dumping data for table `spip_formulaires_liens`
460--
461
462LOCK TABLES `spip_formulaires_liens` WRITE;
463/*!40000 ALTER TABLE `spip_formulaires_liens` DISABLE KEYS */;
464/*!40000 ALTER TABLE `spip_formulaires_liens` ENABLE KEYS */;
465UNLOCK TABLES;
466
467--
468-- Table structure for table `spip_formulaires_reponses`
469--
470
471DROP TABLE IF EXISTS `spip_formulaires_reponses`;
472/*!40101 SET @saved_cs_client = @@character_set_client */;
473/*!40101 SET character_set_client = utf8 */;
474CREATE TABLE `spip_formulaires_reponses` (
475 `id_formulaires_reponse` bigint(21) NOT NULL AUTO_INCREMENT,
476 `id_formulaire` bigint(21) NOT NULL DEFAULT '0',
477 `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
478 `ip` varchar(255) NOT NULL DEFAULT '',
479 `id_auteur` bigint(21) NOT NULL DEFAULT '0',
480 `cookie` varchar(255) NOT NULL DEFAULT '',
481 `statut` varchar(10) NOT NULL DEFAULT '',
482 `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
483 PRIMARY KEY (`id_formulaires_reponse`),
484 KEY `id_formulaire` (`id_formulaire`),
485 KEY `id_auteur` (`id_auteur`),
486 KEY `cookie` (`cookie`)
487) ENGINE=MyISAM DEFAULT CHARSET=utf8;
488/*!40101 SET character_set_client = @saved_cs_client */;
489
490--
491-- Dumping data for table `spip_formulaires_reponses`
492--
493
494LOCK TABLES `spip_formulaires_reponses` WRITE;
495/*!40000 ALTER TABLE `spip_formulaires_reponses` DISABLE KEYS */;
496/*!40000 ALTER TABLE `spip_formulaires_reponses` ENABLE KEYS */;
497UNLOCK TABLES;
498
499--
500-- Table structure for table `spip_formulaires_reponses_champs`
501--
502
503DROP TABLE IF EXISTS `spip_formulaires_reponses_champs`;
504/*!40101 SET @saved_cs_client = @@character_set_client */;
505/*!40101 SET character_set_client = utf8 */;
506CREATE TABLE `spip_formulaires_reponses_champs` (
507 `id_formulaires_reponses_champ` bigint(21) NOT NULL AUTO_INCREMENT,
508 `id_formulaires_reponse` bigint(21) NOT NULL DEFAULT '0',
509 `nom` varchar(255) NOT NULL DEFAULT '',
510 `valeur` text NOT NULL,
511 `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
512 PRIMARY KEY (`id_formulaires_reponses_champ`),
513 UNIQUE KEY `reponse` (`id_formulaires_reponse`,`nom`),
514 KEY `id_formulaires_reponse` (`id_formulaires_reponse`),
515 KEY `nom` (`nom`)
516) ENGINE=MyISAM DEFAULT CHARSET=utf8;
517/*!40101 SET character_set_client = @saved_cs_client */;
518
519--
520-- Dumping data for table `spip_formulaires_reponses_champs`
521--
522
523LOCK TABLES `spip_formulaires_reponses_champs` WRITE;
524/*!40000 ALTER TABLE `spip_formulaires_reponses_champs` DISABLE KEYS */;
525/*!40000 ALTER TABLE `spip_formulaires_reponses_champs` ENABLE KEYS */;
526UNLOCK TABLES;
527
528--
529-- Table structure for table `spip_forum`
530--
531
532DROP TABLE IF EXISTS `spip_forum`;
533/*!40101 SET @saved_cs_client = @@character_set_client */;
534/*!40101 SET character_set_client = utf8 */;
535CREATE TABLE `spip_forum` (
536 `id_forum` bigint(21) NOT NULL AUTO_INCREMENT,
537 `id_objet` bigint(21) NOT NULL DEFAULT '0',
538 `objet` varchar(25) NOT NULL DEFAULT '',
539 `id_parent` bigint(21) NOT NULL DEFAULT '0',
540 `id_thread` bigint(21) NOT NULL DEFAULT '0',
541 `date_heure` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
542 `date_thread` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
543 `titre` text NOT NULL,
544 `texte` mediumtext NOT NULL,
545 `auteur` text NOT NULL,
546 `email_auteur` text NOT NULL,
547 `nom_site` text NOT NULL,
548 `url_site` text NOT NULL,
549 `statut` varchar(8) NOT NULL DEFAULT '0',
550 `ip` varchar(40) NOT NULL DEFAULT '',
551 `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
552 `id_auteur` bigint(20) NOT NULL DEFAULT '0',
553 PRIMARY KEY (`id_forum`),
554 KEY `id_auteur` (`id_auteur`),
555 KEY `id_parent` (`id_parent`),
556 KEY `id_thread` (`id_thread`),
557 KEY `optimal` (`statut`,`id_parent`,`id_objet`,`objet`,`date_heure`)
558) ENGINE=MyISAM DEFAULT CHARSET=utf8;
559/*!40101 SET character_set_client = @saved_cs_client */;
560
561--
562-- Dumping data for table `spip_forum`
563--
564
565LOCK TABLES `spip_forum` WRITE;
566/*!40000 ALTER TABLE `spip_forum` DISABLE KEYS */;
567/*!40000 ALTER TABLE `spip_forum` ENABLE KEYS */;
568UNLOCK TABLES;
569
570--
571-- Table structure for table `spip_groupes_mots`
572--
573
574DROP TABLE IF EXISTS `spip_groupes_mots`;
575/*!40101 SET @saved_cs_client = @@character_set_client */;
576/*!40101 SET character_set_client = utf8 */;
577CREATE TABLE `spip_groupes_mots` (
578 `id_groupe` bigint(21) NOT NULL AUTO_INCREMENT,
579 `titre` text NOT NULL,
580 `descriptif` text NOT NULL,
581 `texte` longtext NOT NULL,
582 `unseul` varchar(3) NOT NULL DEFAULT '',
583 `obligatoire` varchar(3) NOT NULL DEFAULT '',
584 `tables_liees` text NOT NULL,
585 `minirezo` varchar(3) NOT NULL DEFAULT '',
586 `comite` varchar(3) NOT NULL DEFAULT '',
587 `forum` varchar(3) NOT NULL DEFAULT '',
588 `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
589 PRIMARY KEY (`id_groupe`)
590) ENGINE=MyISAM DEFAULT CHARSET=utf8;
591/*!40101 SET character_set_client = @saved_cs_client */;
592
593--
594-- Dumping data for table `spip_groupes_mots`
595--
596
597LOCK TABLES `spip_groupes_mots` WRITE;
598/*!40000 ALTER TABLE `spip_groupes_mots` DISABLE KEYS */;
599/*!40000 ALTER TABLE `spip_groupes_mots` ENABLE KEYS */;
600UNLOCK TABLES;
601
602--
603-- Table structure for table `spip_jobs`
604--
605
606DROP TABLE IF EXISTS `spip_jobs`;
607/*!40101 SET @saved_cs_client = @@character_set_client */;
608/*!40101 SET character_set_client = utf8 */;
609CREATE TABLE `spip_jobs` (
610 `id_job` bigint(21) NOT NULL AUTO_INCREMENT,
611 `descriptif` text NOT NULL,
612 `fonction` varchar(255) NOT NULL,
613 `args` longblob NOT NULL,
614 `md5args` char(32) NOT NULL DEFAULT '',
615 `inclure` varchar(255) NOT NULL,
616 `priorite` smallint(6) NOT NULL DEFAULT '0',
617 `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
618 `status` tinyint(4) NOT NULL DEFAULT '1',
619 PRIMARY KEY (`id_job`),
620 KEY `date` (`date`),
621 KEY `status` (`status`)
622) ENGINE=MyISAM DEFAULT CHARSET=utf8;
623/*!40101 SET character_set_client = @saved_cs_client */;
624
625--
626-- Dumping data for table `spip_jobs`
627--
628
629LOCK TABLES `spip_jobs` WRITE;
630/*!40000 ALTER TABLE `spip_jobs` DISABLE KEYS */;
631/*!40000 ALTER TABLE `spip_jobs` ENABLE KEYS */;
632UNLOCK TABLES;
633
634--
635-- Table structure for table `spip_jobs_liens`
636--
637
638DROP TABLE IF EXISTS `spip_jobs_liens`;
639/*!40101 SET @saved_cs_client = @@character_set_client */;
640/*!40101 SET character_set_client = utf8 */;
641CREATE TABLE `spip_jobs_liens` (
642 `id_job` bigint(21) NOT NULL DEFAULT '0',
643 `id_objet` bigint(21) NOT NULL DEFAULT '0',
644 `objet` varchar(25) NOT NULL DEFAULT '',
645 PRIMARY KEY (`id_job`,`id_objet`,`objet`),
646 KEY `id_job` (`id_job`)
647) ENGINE=MyISAM DEFAULT CHARSET=utf8;
648/*!40101 SET character_set_client = @saved_cs_client */;
649
650--
651-- Dumping data for table `spip_jobs_liens`
652--
653
654LOCK TABLES `spip_jobs_liens` WRITE;
655/*!40000 ALTER TABLE `spip_jobs_liens` DISABLE KEYS */;
656/*!40000 ALTER TABLE `spip_jobs_liens` ENABLE KEYS */;
657UNLOCK TABLES;
658
659--
660-- Table structure for table `spip_mailshots`
661--
662
663DROP TABLE IF EXISTS `spip_mailshots`;
664/*!40101 SET @saved_cs_client = @@character_set_client */;
665/*!40101 SET character_set_client = utf8 */;
666CREATE TABLE `spip_mailshots` (
667 `id_mailshot` bigint(21) NOT NULL AUTO_INCREMENT,
668 `id` varchar(32) NOT NULL DEFAULT '',
669 `sujet` text NOT NULL,
670 `html` longtext NOT NULL,
671 `texte` longtext NOT NULL,
672 `listes` text NOT NULL,
673 `from_name` text NOT NULL,
674 `from_email` text NOT NULL,
675 `total` bigint(21) NOT NULL,
676 `current` bigint(21) NOT NULL,
677 `failed` bigint(21) NOT NULL,
678 `nb_read` bigint(21) NOT NULL,
679 `nb_clic` bigint(21) NOT NULL,
680 `nb_spam` bigint(21) NOT NULL,
681 `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
682 `date_start` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
683 `statut` varchar(20) NOT NULL DEFAULT 'processing',
684 `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
685 PRIMARY KEY (`id_mailshot`),
686 KEY `statut` (`statut`)
687) ENGINE=MyISAM DEFAULT CHARSET=utf8;
688/*!40101 SET character_set_client = @saved_cs_client */;
689
690--
691-- Dumping data for table `spip_mailshots`
692--
693
694LOCK TABLES `spip_mailshots` WRITE;
695/*!40000 ALTER TABLE `spip_mailshots` DISABLE KEYS */;
696/*!40000 ALTER TABLE `spip_mailshots` ENABLE KEYS */;
697UNLOCK TABLES;
698
699--
700-- Table structure for table `spip_mailshots_destinataires`
701--
702
703DROP TABLE IF EXISTS `spip_mailshots_destinataires`;
704/*!40101 SET @saved_cs_client = @@character_set_client */;
705/*!40101 SET character_set_client = utf8 */;
706CREATE TABLE `spip_mailshots_destinataires` (
707 `id_mailshot` bigint(21) NOT NULL DEFAULT '0',
708 `email` varchar(255) NOT NULL DEFAULT '',
709 `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
710 `statut` char(4) NOT NULL DEFAULT 'todo',
711 `try` tinyint(4) NOT NULL DEFAULT '0',
712 PRIMARY KEY (`id_mailshot`,`email`),
713 KEY `email` (`email`),
714 KEY `statut` (`statut`)
715) ENGINE=MyISAM DEFAULT CHARSET=utf8;
716/*!40101 SET character_set_client = @saved_cs_client */;
717
718--
719-- Dumping data for table `spip_mailshots_destinataires`
720--
721
722LOCK TABLES `spip_mailshots_destinataires` WRITE;
723/*!40000 ALTER TABLE `spip_mailshots_destinataires` DISABLE KEYS */;
724/*!40000 ALTER TABLE `spip_mailshots_destinataires` ENABLE KEYS */;
725UNLOCK TABLES;
726
727--
728-- Table structure for table `spip_mailsubscribers`
729--
730
731DROP TABLE IF EXISTS `spip_mailsubscribers`;
732/*!40101 SET @saved_cs_client = @@character_set_client */;
733/*!40101 SET character_set_client = utf8 */;
734CREATE TABLE `spip_mailsubscribers` (
735 `id_mailsubscriber` bigint(21) NOT NULL AUTO_INCREMENT,
736 `email` varchar(255) NOT NULL DEFAULT '',
737 `nom` text NOT NULL,
738 `optin` text NOT NULL,
739 `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
740 `statut` varchar(20) NOT NULL DEFAULT 'prepa',
741 `jeton` char(25) NOT NULL DEFAULT '',
742 `lang` varchar(10) NOT NULL DEFAULT '',
743 `invite_email_from` text NOT NULL,
744 `invite_email_text` text NOT NULL,
745 `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
746 PRIMARY KEY (`id_mailsubscriber`),
747 UNIQUE KEY `email` (`email`),
748 KEY `lang` (`lang`),
749 KEY `statut` (`statut`)
750) ENGINE=MyISAM DEFAULT CHARSET=utf8;
751/*!40101 SET character_set_client = @saved_cs_client */;
752
753--
754-- Dumping data for table `spip_mailsubscribers`
755--
756
757LOCK TABLES `spip_mailsubscribers` WRITE;
758/*!40000 ALTER TABLE `spip_mailsubscribers` DISABLE KEYS */;
759/*!40000 ALTER TABLE `spip_mailsubscribers` ENABLE KEYS */;
760UNLOCK TABLES;
761
762--
763-- Table structure for table `spip_mailsubscribinglists`
764--
765
766DROP TABLE IF EXISTS `spip_mailsubscribinglists`;
767/*!40101 SET @saved_cs_client = @@character_set_client */;
768/*!40101 SET character_set_client = utf8 */;
769CREATE TABLE `spip_mailsubscribinglists` (
770 `id_mailsubscribinglist` bigint(21) NOT NULL AUTO_INCREMENT,
771 `identifiant` varchar(255) NOT NULL DEFAULT '',
772 `titre` text NOT NULL,
773 `descriptif` text NOT NULL,
774 `adresse_envoi_nom` text NOT NULL,
775 `adresse_envoi_email` text NOT NULL,
776 `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
777 `statut` varchar(20) NOT NULL DEFAULT 'prepa',
778 `segments` text NOT NULL,
779 `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
780 PRIMARY KEY (`id_mailsubscribinglist`),
781 UNIQUE KEY `identifiant` (`identifiant`),
782 KEY `statut` (`statut`)
783) ENGINE=MyISAM DEFAULT CHARSET=utf8;
784/*!40101 SET character_set_client = @saved_cs_client */;
785
786--
787-- Dumping data for table `spip_mailsubscribinglists`
788--
789
790LOCK TABLES `spip_mailsubscribinglists` WRITE;
791/*!40000 ALTER TABLE `spip_mailsubscribinglists` DISABLE KEYS */;
792/*!40000 ALTER TABLE `spip_mailsubscribinglists` ENABLE KEYS */;
793UNLOCK TABLES;
794
795--
796-- Table structure for table `spip_mailsubscriptions`
797--
798
799DROP TABLE IF EXISTS `spip_mailsubscriptions`;
800/*!40101 SET @saved_cs_client = @@character_set_client */;
801/*!40101 SET character_set_client = utf8 */;
802CREATE TABLE `spip_mailsubscriptions` (
803 `id_mailsubscriber` bigint(21) NOT NULL DEFAULT '0',
804 `id_mailsubscribinglist` bigint(21) NOT NULL DEFAULT '0',
805 `id_segment` smallint(6) NOT NULL DEFAULT '0',
806 `statut` varchar(20) NOT NULL DEFAULT 'prop',
807 `actualise_segments` tinyint(4) NOT NULL DEFAULT '0',
808 `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
809 PRIMARY KEY (`id_mailsubscriber`,`id_mailsubscribinglist`,`id_segment`),
810 KEY `id_mailsubscriber` (`id_mailsubscriber`),
811 KEY `id_mailsubscribinglist` (`id_mailsubscribinglist`),
812 KEY `id_segment` (`id_segment`),
813 KEY `statut` (`statut`)
814) ENGINE=MyISAM DEFAULT CHARSET=utf8;
815/*!40101 SET character_set_client = @saved_cs_client */;
816
817--
818-- Dumping data for table `spip_mailsubscriptions`
819--
820
821LOCK TABLES `spip_mailsubscriptions` WRITE;
822/*!40000 ALTER TABLE `spip_mailsubscriptions` DISABLE KEYS */;
823/*!40000 ALTER TABLE `spip_mailsubscriptions` ENABLE KEYS */;
824UNLOCK TABLES;
825
826--
827-- Table structure for table `spip_messages`
828--
829
830DROP TABLE IF EXISTS `spip_messages`;
831/*!40101 SET @saved_cs_client = @@character_set_client */;
832/*!40101 SET character_set_client = utf8 */;
833CREATE TABLE `spip_messages` (
834 `id_message` bigint(21) NOT NULL AUTO_INCREMENT,
835 `titre` text NOT NULL,
836 `texte` longtext NOT NULL,
837 `type` varchar(6) NOT NULL DEFAULT '',
838 `date_heure` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
839 `date_fin` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
840 `rv` varchar(3) NOT NULL DEFAULT '',
841 `statut` varchar(6) NOT NULL DEFAULT '0',
842 `id_auteur` bigint(21) NOT NULL DEFAULT '0',
843 `destinataires` text NOT NULL,
844 `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
845 PRIMARY KEY (`id_message`),
846 KEY `id_auteur` (`id_auteur`)
847) ENGINE=MyISAM DEFAULT CHARSET=utf8;
848/*!40101 SET character_set_client = @saved_cs_client */;
849
850--
851-- Dumping data for table `spip_messages`
852--
853
854LOCK TABLES `spip_messages` WRITE;
855/*!40000 ALTER TABLE `spip_messages` DISABLE KEYS */;
856/*!40000 ALTER TABLE `spip_messages` ENABLE KEYS */;
857UNLOCK TABLES;
858
859--
860-- Table structure for table `spip_meta`
861--
862
863DROP TABLE IF EXISTS `spip_meta`;
864/*!40101 SET @saved_cs_client = @@character_set_client */;
865/*!40101 SET character_set_client = utf8 */;
866CREATE TABLE `spip_meta` (
867 `nom` varchar(255) NOT NULL,
868 `valeur` text,
869 `impt` enum('non','oui') NOT NULL DEFAULT 'oui',
870 `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
871 PRIMARY KEY (`nom`)
872) ENGINE=MyISAM DEFAULT CHARSET=utf8;
873/*!40101 SET character_set_client = @saved_cs_client */;
874
875--
876-- Dumping data for table `spip_meta`
877--
878
879LOCK TABLES `spip_meta` WRITE;
880/*!40000 ALTER TABLE `spip_meta` DISABLE KEYS */;
881/*!40000 ALTER TABLE `spip_meta` ENABLE KEYS */;
882UNLOCK TABLES;
883
884--
885-- Table structure for table `spip_mots`
886--
887
888DROP TABLE IF EXISTS `spip_mots`;
889/*!40101 SET @saved_cs_client = @@character_set_client */;
890/*!40101 SET character_set_client = utf8 */;
891CREATE TABLE `spip_mots` (
892 `id_mot` bigint(21) NOT NULL AUTO_INCREMENT,
893 `titre` text NOT NULL,
894 `descriptif` text NOT NULL,
895 `texte` longtext NOT NULL,
896 `id_groupe` bigint(21) NOT NULL DEFAULT '0',
897 `type` text NOT NULL,
898 `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
899 PRIMARY KEY (`id_mot`),
900 KEY `id_groupe` (`id_groupe`)
901) ENGINE=MyISAM DEFAULT CHARSET=utf8;
902/*!40101 SET character_set_client = @saved_cs_client */;
903
904--
905-- Dumping data for table `spip_mots`
906--
907
908LOCK TABLES `spip_mots` WRITE;
909/*!40000 ALTER TABLE `spip_mots` DISABLE KEYS */;
910/*!40000 ALTER TABLE `spip_mots` ENABLE KEYS */;
911UNLOCK TABLES;
912
913--
914-- Table structure for table `spip_mots_liens`
915--
916
917DROP TABLE IF EXISTS `spip_mots_liens`;
918/*!40101 SET @saved_cs_client = @@character_set_client */;
919/*!40101 SET character_set_client = utf8 */;
920CREATE TABLE `spip_mots_liens` (
921 `id_mot` bigint(21) NOT NULL DEFAULT '0',
922 `id_objet` bigint(21) NOT NULL DEFAULT '0',
923 `objet` varchar(25) NOT NULL DEFAULT '',
924 PRIMARY KEY (`id_mot`,`id_objet`,`objet`),
925 KEY `id_mot` (`id_mot`),
926 KEY `id_objet` (`id_objet`),
927 KEY `objet` (`objet`)
928) ENGINE=MyISAM DEFAULT CHARSET=utf8;
929/*!40101 SET character_set_client = @saved_cs_client */;
930
931--
932-- Dumping data for table `spip_mots_liens`
933--
934
935LOCK TABLES `spip_mots_liens` WRITE;
936/*!40000 ALTER TABLE `spip_mots_liens` DISABLE KEYS */;
937/*!40000 ALTER TABLE `spip_mots_liens` ENABLE KEYS */;
938UNLOCK TABLES;
939
940--
941-- Table structure for table `spip_newsletters`
942--
943
944DROP TABLE IF EXISTS `spip_newsletters`;
945/*!40101 SET @saved_cs_client = @@character_set_client */;
946/*!40101 SET character_set_client = utf8 */;
947CREATE TABLE `spip_newsletters` (
948 `id_newsletter` bigint(21) NOT NULL AUTO_INCREMENT,
949 `titre` text NOT NULL,
950 `chapo` mediumtext NOT NULL,
951 `texte` longtext NOT NULL,
952 `date_redac` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
953 `patron` text NOT NULL,
954 `baked` tinyint(4) NOT NULL DEFAULT '0',
955 `html_email` longtext NOT NULL,
956 `texte_email` longtext NOT NULL,
957 `html_page` longtext NOT NULL,
958 `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
959 `recurrence` text NOT NULL,
960 `email_test` text NOT NULL,
961 `liste` text NOT NULL,
962 `adresse_envoi_nom` text NOT NULL,
963 `adresse_envoi_email` text NOT NULL,
964 `statut` varchar(20) NOT NULL DEFAULT '0',
965 `lang` varchar(10) NOT NULL DEFAULT '',
966 `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
967 PRIMARY KEY (`id_newsletter`),
968 KEY `lang` (`lang`),
969 KEY `statut` (`statut`)
970) ENGINE=MyISAM DEFAULT CHARSET=utf8;
971/*!40101 SET character_set_client = @saved_cs_client */;
972
973--
974-- Dumping data for table `spip_newsletters`
975--
976
977LOCK TABLES `spip_newsletters` WRITE;
978/*!40000 ALTER TABLE `spip_newsletters` DISABLE KEYS */;
979/*!40000 ALTER TABLE `spip_newsletters` ENABLE KEYS */;
980UNLOCK TABLES;
981
982--
983-- Table structure for table `spip_newsletters_liens`
984--
985
986DROP TABLE IF EXISTS `spip_newsletters_liens`;
987/*!40101 SET @saved_cs_client = @@character_set_client */;
988/*!40101 SET character_set_client = utf8 */;
989CREATE TABLE `spip_newsletters_liens` (
990 `id_newsletter` bigint(21) NOT NULL DEFAULT '0',
991 `id_objet` bigint(21) NOT NULL DEFAULT '0',
992 `objet` varchar(25) NOT NULL DEFAULT '',
993 `vu` varchar(6) NOT NULL DEFAULT 'non',
994 PRIMARY KEY (`id_newsletter`,`id_objet`,`objet`),
995 KEY `id_newsletter` (`id_newsletter`)
996) ENGINE=MyISAM DEFAULT CHARSET=utf8;
997/*!40101 SET character_set_client = @saved_cs_client */;
998
999--
1000-- Dumping data for table `spip_newsletters_liens`
1001--
1002
1003LOCK TABLES `spip_newsletters_liens` WRITE;
1004/*!40000 ALTER TABLE `spip_newsletters_liens` DISABLE KEYS */;
1005/*!40000 ALTER TABLE `spip_newsletters_liens` ENABLE KEYS */;
1006UNLOCK TABLES;
1007
1008--
1009-- Table structure for table `spip_paquets`
1010--
1011
1012DROP TABLE IF EXISTS `spip_paquets`;
1013/*!40101 SET @saved_cs_client = @@character_set_client */;
1014/*!40101 SET character_set_client = utf8 */;
1015CREATE TABLE `spip_paquets` (
1016 `id_paquet` bigint(21) NOT NULL AUTO_INCREMENT,
1017 `id_plugin` bigint(21) NOT NULL,
1018 `prefixe` varchar(30) NOT NULL DEFAULT '',
1019 `logo` varchar(255) NOT NULL DEFAULT '',
1020 `version` varchar(24) NOT NULL DEFAULT '',
1021 `version_base` varchar(24) NOT NULL DEFAULT '',
1022 `compatibilite_spip` varchar(24) NOT NULL DEFAULT '',
1023 `branches_spip` varchar(255) NOT NULL DEFAULT '',
1024 `description` text NOT NULL,
1025 `auteur` text NOT NULL,
1026 `credit` text NOT NULL,
1027 `licence` text NOT NULL,
1028 `copyright` text NOT NULL,
1029 `lien_doc` text NOT NULL,
1030 `lien_demo` text NOT NULL,
1031 `lien_dev` text NOT NULL,
1032 `etat` varchar(16) NOT NULL DEFAULT '',
1033 `etatnum` int(1) NOT NULL DEFAULT '0',
1034 `dependances` text NOT NULL,
1035 `procure` text NOT NULL,
1036 `date_crea` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1037 `date_modif` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1038 `id_depot` bigint(21) NOT NULL DEFAULT '0',
1039 `nom_archive` varchar(255) NOT NULL DEFAULT '',
1040 `nbo_archive` int(11) NOT NULL DEFAULT '0',
1041 `maj_archive` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1042 `src_archive` varchar(255) NOT NULL DEFAULT '',
1043 `traductions` text NOT NULL,
1044 `actif` varchar(3) NOT NULL DEFAULT 'non',
1045 `installe` varchar(3) NOT NULL DEFAULT 'non',
1046 `recent` int(2) NOT NULL DEFAULT '0',
1047 `maj_version` varchar(255) NOT NULL DEFAULT '',
1048 `superieur` varchar(3) NOT NULL DEFAULT 'non',
1049 `obsolete` varchar(3) NOT NULL DEFAULT 'non',
1050 `attente` varchar(3) NOT NULL DEFAULT 'non',
1051 `constante` varchar(30) NOT NULL DEFAULT '',
1052 `signature` varchar(32) NOT NULL DEFAULT '',
1053 PRIMARY KEY (`id_paquet`),
1054 KEY `id_plugin` (`id_plugin`)
1055) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1056/*!40101 SET character_set_client = @saved_cs_client */;
1057
1058--
1059-- Dumping data for table `spip_paquets`
1060--
1061
1062LOCK TABLES `spip_paquets` WRITE;
1063/*!40000 ALTER TABLE `spip_paquets` DISABLE KEYS */;
1064/*!40000 ALTER TABLE `spip_paquets` ENABLE KEYS */;
1065UNLOCK TABLES;
1066
1067--
1068-- Table structure for table `spip_petitions`
1069--
1070
1071DROP TABLE IF EXISTS `spip_petitions`;
1072/*!40101 SET @saved_cs_client = @@character_set_client */;
1073/*!40101 SET character_set_client = utf8 */;
1074CREATE TABLE `spip_petitions` (
1075 `id_petition` bigint(21) NOT NULL AUTO_INCREMENT,
1076 `id_article` bigint(21) NOT NULL DEFAULT '0',
1077 `email_unique` char(3) NOT NULL DEFAULT '',
1078 `site_obli` char(3) NOT NULL DEFAULT '',
1079 `site_unique` char(3) NOT NULL DEFAULT '',
1080 `message` char(3) NOT NULL DEFAULT '',
1081 `texte` longtext NOT NULL,
1082 `statut` varchar(10) NOT NULL DEFAULT 'publie',
1083 `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1084 PRIMARY KEY (`id_petition`),
1085 UNIQUE KEY `id_article` (`id_article`)
1086) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1087/*!40101 SET character_set_client = @saved_cs_client */;
1088
1089--
1090-- Dumping data for table `spip_petitions`
1091--
1092
1093LOCK TABLES `spip_petitions` WRITE;
1094/*!40000 ALTER TABLE `spip_petitions` DISABLE KEYS */;
1095/*!40000 ALTER TABLE `spip_petitions` ENABLE KEYS */;
1096UNLOCK TABLES;
1097
1098--
1099-- Table structure for table `spip_plugins`
1100--
1101
1102DROP TABLE IF EXISTS `spip_plugins`;
1103/*!40101 SET @saved_cs_client = @@character_set_client */;
1104/*!40101 SET character_set_client = utf8 */;
1105CREATE TABLE `spip_plugins` (
1106 `id_plugin` bigint(21) NOT NULL AUTO_INCREMENT,
1107 `prefixe` varchar(30) NOT NULL DEFAULT '',
1108 `nom` text NOT NULL,
1109 `slogan` text NOT NULL,
1110 `categorie` varchar(100) NOT NULL DEFAULT '',
1111 `tags` text NOT NULL,
1112 `vmax` varchar(24) NOT NULL DEFAULT '',
1113 `date_crea` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1114 `date_modif` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1115 `compatibilite_spip` varchar(24) NOT NULL DEFAULT '',
1116 `branches_spip` varchar(255) NOT NULL DEFAULT '',
1117 `nbr_sites` int(11) NOT NULL DEFAULT '0',
1118 `popularite` double NOT NULL DEFAULT '0',
1119 PRIMARY KEY (`id_plugin`),
1120 KEY `prefixe` (`prefixe`)
1121) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1122/*!40101 SET character_set_client = @saved_cs_client */;
1123
1124--
1125-- Dumping data for table `spip_plugins`
1126--
1127
1128LOCK TABLES `spip_plugins` WRITE;
1129/*!40000 ALTER TABLE `spip_plugins` DISABLE KEYS */;
1130/*!40000 ALTER TABLE `spip_plugins` ENABLE KEYS */;
1131UNLOCK TABLES;
1132
1133--
1134-- Table structure for table `spip_plugins_stats`
1135--
1136
1137DROP TABLE IF EXISTS `spip_plugins_stats`;
1138/*!40101 SET @saved_cs_client = @@character_set_client */;
1139/*!40101 SET character_set_client = utf8 */;
1140CREATE TABLE `spip_plugins_stats` (
1141 `prefixe` varchar(30) NOT NULL DEFAULT '',
1142 `branche_spip` varchar(255) NOT NULL DEFAULT '',
1143 `nbr_sites` int(11) NOT NULL DEFAULT '0',
1144 `popularite` double NOT NULL DEFAULT '0',
1145 `historique` text NOT NULL,
1146 `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1147 PRIMARY KEY (`prefixe`,`branche_spip`)
1148) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1149/*!40101 SET character_set_client = @saved_cs_client */;
1150
1151--
1152-- Dumping data for table `spip_plugins_stats`
1153--
1154
1155LOCK TABLES `spip_plugins_stats` WRITE;
1156/*!40000 ALTER TABLE `spip_plugins_stats` DISABLE KEYS */;
1157/*!40000 ALTER TABLE `spip_plugins_stats` ENABLE KEYS */;
1158UNLOCK TABLES;
1159
1160--
1161-- Table structure for table `spip_referers`
1162--
1163
1164DROP TABLE IF EXISTS `spip_referers`;
1165/*!40101 SET @saved_cs_client = @@character_set_client */;
1166/*!40101 SET character_set_client = utf8 */;
1167CREATE TABLE `spip_referers` (
1168 `referer_md5` bigint(20) unsigned NOT NULL,
1169 `date` date NOT NULL,
1170 `referer` varchar(255) DEFAULT NULL,
1171 `visites` int(10) unsigned NOT NULL,
1172 `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1173 `visites_veille` int(10) unsigned NOT NULL DEFAULT '0',
1174 `visites_jour` int(10) unsigned NOT NULL DEFAULT '0',
1175 PRIMARY KEY (`referer_md5`)
1176) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1177/*!40101 SET character_set_client = @saved_cs_client */;
1178
1179--
1180-- Dumping data for table `spip_referers`
1181--
1182
1183LOCK TABLES `spip_referers` WRITE;
1184/*!40000 ALTER TABLE `spip_referers` DISABLE KEYS */;
1185/*!40000 ALTER TABLE `spip_referers` ENABLE KEYS */;
1186UNLOCK TABLES;
1187
1188--
1189-- Table structure for table `spip_referers_articles`
1190--
1191
1192DROP TABLE IF EXISTS `spip_referers_articles`;
1193/*!40101 SET @saved_cs_client = @@character_set_client */;
1194/*!40101 SET character_set_client = utf8 */;
1195CREATE TABLE `spip_referers_articles` (
1196 `id_article` int(10) unsigned NOT NULL,
1197 `referer_md5` bigint(20) unsigned NOT NULL,
1198 `referer` varchar(255) NOT NULL DEFAULT '',
1199 `visites` int(10) unsigned NOT NULL,
1200 `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1201 PRIMARY KEY (`id_article`,`referer_md5`),
1202 KEY `referer_md5` (`referer_md5`)
1203) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1204/*!40101 SET character_set_client = @saved_cs_client */;
1205
1206--
1207-- Dumping data for table `spip_referers_articles`
1208--
1209
1210LOCK TABLES `spip_referers_articles` WRITE;
1211/*!40000 ALTER TABLE `spip_referers_articles` DISABLE KEYS */;
1212/*!40000 ALTER TABLE `spip_referers_articles` ENABLE KEYS */;
1213UNLOCK TABLES;
1214
1215--
1216-- Table structure for table `spip_resultats`
1217--
1218
1219DROP TABLE IF EXISTS `spip_resultats`;
1220/*!40101 SET @saved_cs_client = @@character_set_client */;
1221/*!40101 SET character_set_client = utf8 */;
1222CREATE TABLE `spip_resultats` (
1223 `recherche` char(16) NOT NULL DEFAULT '',
1224 `id` int(10) unsigned NOT NULL,
1225 `points` int(10) unsigned NOT NULL DEFAULT '0',
1226 `table_objet` varchar(30) NOT NULL DEFAULT '',
1227 `serveur` char(16) NOT NULL DEFAULT '',
1228 `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
1229) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1230/*!40101 SET character_set_client = @saved_cs_client */;
1231
1232--
1233-- Dumping data for table `spip_resultats`
1234--
1235
1236LOCK TABLES `spip_resultats` WRITE;
1237/*!40000 ALTER TABLE `spip_resultats` DISABLE KEYS */;
1238/*!40000 ALTER TABLE `spip_resultats` ENABLE KEYS */;
1239UNLOCK TABLES;
1240
1241--
1242-- Table structure for table `spip_rubriques`
1243--
1244
1245DROP TABLE IF EXISTS `spip_rubriques`;
1246/*!40101 SET @saved_cs_client = @@character_set_client */;
1247/*!40101 SET character_set_client = utf8 */;
1248CREATE TABLE `spip_rubriques` (
1249 `id_rubrique` bigint(21) NOT NULL AUTO_INCREMENT,
1250 `id_parent` bigint(21) NOT NULL DEFAULT '0',
1251 `titre` text NOT NULL,
1252 `descriptif` text NOT NULL,
1253 `texte` longtext NOT NULL,
1254 `id_secteur` bigint(21) NOT NULL DEFAULT '0',
1255 `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1256 `statut` varchar(10) NOT NULL DEFAULT '0',
1257 `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1258 `lang` varchar(10) NOT NULL DEFAULT '',
1259 `langue_choisie` varchar(3) DEFAULT 'non',
1260 `statut_tmp` varchar(10) NOT NULL DEFAULT '0',
1261 `date_tmp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1262 `profondeur` smallint(5) NOT NULL DEFAULT '0',
1263 `agenda` tinyint(1) NOT NULL DEFAULT '0',
1264 PRIMARY KEY (`id_rubrique`),
1265 KEY `lang` (`lang`),
1266 KEY `id_parent` (`id_parent`)
1267) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1268/*!40101 SET character_set_client = @saved_cs_client */;
1269
1270--
1271-- Dumping data for table `spip_rubriques`
1272--
1273
1274LOCK TABLES `spip_rubriques` WRITE;
1275/*!40000 ALTER TABLE `spip_rubriques` DISABLE KEYS */;
1276/*!40000 ALTER TABLE `spip_rubriques` ENABLE KEYS */;
1277UNLOCK TABLES;
1278
1279--
1280-- Table structure for table `spip_shoutbox`
1281--
1282
1283DROP TABLE IF EXISTS `spip_shoutbox`;
1284/*!40101 SET @saved_cs_client = @@character_set_client */;
1285/*!40101 SET character_set_client = utf8 */;
1286CREATE TABLE `spip_shoutbox` (
1287 `id_shoutbox` bigint(21) NOT NULL AUTO_INCREMENT,
1288 `objet` varchar(25) NOT NULL DEFAULT '',
1289 `id_auteur` bigint(21) DEFAULT NULL,
1290 `auteur` text NOT NULL,
1291 `texte` longtext NOT NULL,
1292 `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1293 `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1294 PRIMARY KEY (`id_shoutbox`),
1295 KEY `objet` (`objet`),
1296 KEY `id_auteur` (`id_auteur`)
1297) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1298/*!40101 SET character_set_client = @saved_cs_client */;
1299
1300--
1301-- Dumping data for table `spip_shoutbox`
1302--
1303
1304LOCK TABLES `spip_shoutbox` WRITE;
1305/*!40000 ALTER TABLE `spip_shoutbox` DISABLE KEYS */;
1306/*!40000 ALTER TABLE `spip_shoutbox` ENABLE KEYS */;
1307UNLOCK TABLES;
1308
1309--
1310-- Table structure for table `spip_signatures`
1311--
1312
1313DROP TABLE IF EXISTS `spip_signatures`;
1314/*!40101 SET @saved_cs_client = @@character_set_client */;
1315/*!40101 SET character_set_client = utf8 */;
1316CREATE TABLE `spip_signatures` (
1317 `id_signature` bigint(21) NOT NULL AUTO_INCREMENT,
1318 `id_petition` bigint(21) NOT NULL DEFAULT '0',
1319 `date_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1320 `nom_email` text NOT NULL,
1321 `ad_email` text NOT NULL,
1322 `nom_site` text NOT NULL,
1323 `url_site` text NOT NULL,
1324 `message` mediumtext NOT NULL,
1325 `statut` varchar(10) NOT NULL DEFAULT '0',
1326 `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1327 PRIMARY KEY (`id_signature`),
1328 KEY `id_petition` (`id_petition`),
1329 KEY `statut` (`statut`)
1330) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1331/*!40101 SET character_set_client = @saved_cs_client */;
1332
1333--
1334-- Dumping data for table `spip_signatures`
1335--
1336
1337LOCK TABLES `spip_signatures` WRITE;
1338/*!40000 ALTER TABLE `spip_signatures` DISABLE KEYS */;
1339/*!40000 ALTER TABLE `spip_signatures` ENABLE KEYS */;
1340UNLOCK TABLES;
1341
1342--
1343-- Table structure for table `spip_syndic`
1344--
1345
1346DROP TABLE IF EXISTS `spip_syndic`;
1347/*!40101 SET @saved_cs_client = @@character_set_client */;
1348/*!40101 SET character_set_client = utf8 */;
1349CREATE TABLE `spip_syndic` (
1350 `id_syndic` bigint(21) NOT NULL AUTO_INCREMENT,
1351 `id_rubrique` bigint(21) NOT NULL DEFAULT '0',
1352 `id_secteur` bigint(21) NOT NULL DEFAULT '0',
1353 `nom_site` text NOT NULL,
1354 `url_site` text NOT NULL,
1355 `url_syndic` text NOT NULL,
1356 `descriptif` text NOT NULL,
1357 `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1358 `syndication` varchar(3) NOT NULL DEFAULT '',
1359 `statut` varchar(10) NOT NULL DEFAULT '0',
1360 `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1361 `date_syndic` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1362 `date_index` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1363 `moderation` varchar(3) DEFAULT 'non',
1364 `miroir` varchar(3) DEFAULT 'non',
1365 `oubli` varchar(3) DEFAULT 'non',
1366 `resume` varchar(3) DEFAULT 'oui',
1367 PRIMARY KEY (`id_syndic`),
1368 KEY `id_rubrique` (`id_rubrique`),
1369 KEY `id_secteur` (`id_secteur`),
1370 KEY `statut` (`statut`,`date_syndic`)
1371) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1372/*!40101 SET character_set_client = @saved_cs_client */;
1373
1374--
1375-- Dumping data for table `spip_syndic`
1376--
1377
1378LOCK TABLES `spip_syndic` WRITE;
1379/*!40000 ALTER TABLE `spip_syndic` DISABLE KEYS */;
1380/*!40000 ALTER TABLE `spip_syndic` ENABLE KEYS */;
1381UNLOCK TABLES;
1382
1383--
1384-- Table structure for table `spip_syndic_articles`
1385--
1386
1387DROP TABLE IF EXISTS `spip_syndic_articles`;
1388/*!40101 SET @saved_cs_client = @@character_set_client */;
1389/*!40101 SET character_set_client = utf8 */;
1390CREATE TABLE `spip_syndic_articles` (
1391 `id_syndic_article` bigint(21) NOT NULL AUTO_INCREMENT,
1392 `id_syndic` bigint(21) NOT NULL DEFAULT '0',
1393 `titre` text NOT NULL,
1394 `url` text NOT NULL,
1395 `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1396 `lesauteurs` text NOT NULL,
1397 `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1398 `statut` varchar(10) NOT NULL DEFAULT '0',
1399 `descriptif` text NOT NULL,
1400 `lang` varchar(10) NOT NULL DEFAULT '',
1401 `url_source` tinytext NOT NULL,
1402 `source` tinytext NOT NULL,
1403 `tags` text NOT NULL,
1404 PRIMARY KEY (`id_syndic_article`),
1405 KEY `id_syndic` (`id_syndic`),
1406 KEY `statut` (`statut`),
1407 KEY `url` (`url`(255))
1408) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1409/*!40101 SET character_set_client = @saved_cs_client */;
1410
1411--
1412-- Dumping data for table `spip_syndic_articles`
1413--
1414
1415LOCK TABLES `spip_syndic_articles` WRITE;
1416/*!40000 ALTER TABLE `spip_syndic_articles` DISABLE KEYS */;
1417/*!40000 ALTER TABLE `spip_syndic_articles` ENABLE KEYS */;
1418UNLOCK TABLES;
1419
1420--
1421-- Table structure for table `spip_types_documents`
1422--
1423
1424DROP TABLE IF EXISTS `spip_types_documents`;
1425/*!40101 SET @saved_cs_client = @@character_set_client */;
1426/*!40101 SET character_set_client = utf8 */;
1427CREATE TABLE `spip_types_documents` (
1428 `extension` varchar(10) NOT NULL DEFAULT '',
1429 `titre` text NOT NULL,
1430 `descriptif` text NOT NULL,
1431 `mime_type` varchar(100) NOT NULL DEFAULT '',
1432 `inclus` enum('non','image','embed') NOT NULL DEFAULT 'non',
1433 `upload` enum('oui','non') NOT NULL DEFAULT 'oui',
1434 `media_defaut` varchar(10) NOT NULL DEFAULT 'file',
1435 `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1436 PRIMARY KEY (`extension`),
1437 KEY `inclus` (`inclus`)
1438) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1439/*!40101 SET character_set_client = @saved_cs_client */;
1440
1441--
1442-- Dumping data for table `spip_types_documents`
1443--
1444
1445LOCK TABLES `spip_types_documents` WRITE;
1446/*!40000 ALTER TABLE `spip_types_documents` DISABLE KEYS */;
1447/*!40000 ALTER TABLE `spip_types_documents` ENABLE KEYS */;
1448UNLOCK TABLES;
1449
1450--
1451-- Table structure for table `spip_urls`
1452--
1453
1454DROP TABLE IF EXISTS `spip_urls`;
1455/*!40101 SET @saved_cs_client = @@character_set_client */;
1456/*!40101 SET character_set_client = utf8 */;
1457CREATE TABLE `spip_urls` (
1458 `id_parent` bigint(21) NOT NULL DEFAULT '0',
1459 `url` varchar(255) NOT NULL,
1460 `type` varchar(25) NOT NULL DEFAULT 'article',
1461 `id_objet` bigint(21) NOT NULL,
1462 `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1463 `segments` smallint(3) NOT NULL DEFAULT '1',
1464 `perma` tinyint(1) NOT NULL DEFAULT '0',
1465 `langue` varchar(10) NOT NULL DEFAULT '',
1466 PRIMARY KEY (`id_parent`,`url`),
1467 KEY `type` (`type`,`id_objet`),
1468 KEY `langue` (`langue`)
1469) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1470/*!40101 SET character_set_client = @saved_cs_client */;
1471
1472--
1473-- Dumping data for table `spip_urls`
1474--
1475
1476LOCK TABLES `spip_urls` WRITE;
1477/*!40000 ALTER TABLE `spip_urls` DISABLE KEYS */;
1478/*!40000 ALTER TABLE `spip_urls` ENABLE KEYS */;
1479UNLOCK TABLES;
1480
1481--
1482-- Table structure for table `spip_versions`
1483--
1484
1485DROP TABLE IF EXISTS `spip_versions`;
1486/*!40101 SET @saved_cs_client = @@character_set_client */;
1487/*!40101 SET character_set_client = utf8 */;
1488CREATE TABLE `spip_versions` (
1489 `id_version` bigint(21) NOT NULL DEFAULT '0',
1490 `id_objet` bigint(21) NOT NULL DEFAULT '0',
1491 `objet` varchar(25) NOT NULL DEFAULT '',
1492 `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1493 `id_auteur` varchar(23) NOT NULL DEFAULT '',
1494 `titre_version` text NOT NULL,
1495 `permanent` char(3) NOT NULL DEFAULT '',
1496 `champs` text NOT NULL,
1497 PRIMARY KEY (`id_version`,`id_objet`,`objet`),
1498 KEY `id_version` (`id_version`),
1499 KEY `id_objet` (`id_objet`),
1500 KEY `objet` (`objet`)
1501) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1502/*!40101 SET character_set_client = @saved_cs_client */;
1503
1504--
1505-- Dumping data for table `spip_versions`
1506--
1507
1508LOCK TABLES `spip_versions` WRITE;
1509/*!40000 ALTER TABLE `spip_versions` DISABLE KEYS */;
1510/*!40000 ALTER TABLE `spip_versions` ENABLE KEYS */;
1511UNLOCK TABLES;
1512
1513--
1514-- Table structure for table `spip_versions_fragments`
1515--
1516
1517DROP TABLE IF EXISTS `spip_versions_fragments`;
1518/*!40101 SET @saved_cs_client = @@character_set_client */;
1519/*!40101 SET character_set_client = utf8 */;
1520CREATE TABLE `spip_versions_fragments` (
1521 `id_fragment` int(10) unsigned NOT NULL DEFAULT '0',
1522 `version_min` int(10) unsigned NOT NULL DEFAULT '0',
1523 `version_max` int(10) unsigned NOT NULL DEFAULT '0',
1524 `id_objet` bigint(21) NOT NULL,
1525 `objet` varchar(25) NOT NULL DEFAULT '',
1526 `compress` tinyint(4) NOT NULL,
1527 `fragment` longblob,
1528 PRIMARY KEY (`id_objet`,`objet`,`id_fragment`,`version_min`)
1529) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1530/*!40101 SET character_set_client = @saved_cs_client */;
1531
1532--
1533-- Dumping data for table `spip_versions_fragments`
1534--
1535
1536LOCK TABLES `spip_versions_fragments` WRITE;
1537/*!40000 ALTER TABLE `spip_versions_fragments` DISABLE KEYS */;
1538/*!40000 ALTER TABLE `spip_versions_fragments` ENABLE KEYS */;
1539UNLOCK TABLES;
1540
1541--
1542-- Table structure for table `spip_visites`
1543--
1544
1545DROP TABLE IF EXISTS `spip_visites`;
1546/*!40101 SET @saved_cs_client = @@character_set_client */;
1547/*!40101 SET character_set_client = utf8 */;
1548CREATE TABLE `spip_visites` (
1549 `date` date NOT NULL,
1550 `visites` int(10) unsigned NOT NULL DEFAULT '0',
1551 `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1552 PRIMARY KEY (`date`)
1553) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1554/*!40101 SET character_set_client = @saved_cs_client */;
1555
1556--
1557-- Dumping data for table `spip_visites`
1558--
1559
1560LOCK TABLES `spip_visites` WRITE;
1561/*!40000 ALTER TABLE `spip_visites` DISABLE KEYS */;
1562/*!40000 ALTER TABLE `spip_visites` ENABLE KEYS */;
1563UNLOCK TABLES;
1564
1565--
1566-- Table structure for table `spip_visites_articles`
1567--
1568
1569DROP TABLE IF EXISTS `spip_visites_articles`;
1570/*!40101 SET @saved_cs_client = @@character_set_client */;
1571/*!40101 SET character_set_client = utf8 */;
1572CREATE TABLE `spip_visites_articles` (
1573 `date` date NOT NULL,
1574 `id_article` int(10) unsigned NOT NULL,
1575 `visites` int(10) unsigned NOT NULL DEFAULT '0',
1576 `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1577 PRIMARY KEY (`date`,`id_article`)
1578) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1579/*!40101 SET character_set_client = @saved_cs_client */;
1580
1581--
1582-- Dumping data for table `spip_visites_articles`
1583--
1584
1585LOCK TABLES `spip_visites_articles` WRITE;
1586/*!40000 ALTER TABLE `spip_visites_articles` DISABLE KEYS */;
1587/*!40000 ALTER TABLE `spip_visites_articles` ENABLE KEYS */;
1588UNLOCK TABLES;
1589
1590--
1591-- Table structure for table `spip_zones`
1592--
1593
1594DROP TABLE IF EXISTS `spip_zones`;
1595/*!40101 SET @saved_cs_client = @@character_set_client */;
1596/*!40101 SET character_set_client = utf8 */;
1597CREATE TABLE `spip_zones` (
1598 `id_zone` bigint(21) NOT NULL AUTO_INCREMENT,
1599 `titre` varchar(255) NOT NULL DEFAULT '',
1600 `descriptif` text NOT NULL,
1601 `publique` char(3) NOT NULL DEFAULT 'oui',
1602 `privee` char(3) NOT NULL DEFAULT 'non',
1603 `autoriser_si_connexion` char(3) NOT NULL DEFAULT 'non',
1604 `maj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1605 PRIMARY KEY (`id_zone`)
1606) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1607/*!40101 SET character_set_client = @saved_cs_client */;
1608
1609--
1610-- Dumping data for table `spip_zones`
1611--
1612
1613LOCK TABLES `spip_zones` WRITE;
1614/*!40000 ALTER TABLE `spip_zones` DISABLE KEYS */;
1615/*!40000 ALTER TABLE `spip_zones` ENABLE KEYS */;
1616UNLOCK TABLES;
1617
1618--
1619-- Table structure for table `spip_zones_liens`
1620--
1621
1622DROP TABLE IF EXISTS `spip_zones_liens`;
1623/*!40101 SET @saved_cs_client = @@character_set_client */;
1624/*!40101 SET character_set_client = utf8 */;
1625CREATE TABLE `spip_zones_liens` (
1626 `id_zone` bigint(21) NOT NULL DEFAULT '0',
1627 `id_objet` bigint(21) NOT NULL DEFAULT '0',
1628 `objet` varchar(25) NOT NULL DEFAULT '',
1629 PRIMARY KEY (`id_zone`,`id_objet`,`objet`),
1630 KEY `id_zone` (`id_zone`)
1631) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1632/*!40101 SET character_set_client = @saved_cs_client */;
1633
1634--
1635-- Dumping data for table `spip_zones_liens`
1636--
1637
1638LOCK TABLES `spip_zones_liens` WRITE;
1639/*!40000 ALTER TABLE `spip_zones_liens` DISABLE KEYS */;
1640/*!40000 ALTER TABLE `spip_zones_liens` ENABLE KEYS */;
1641UNLOCK TABLES;
1642/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1643
1644/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1645/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1646/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1647/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1648/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1649/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1650/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1651
1652-- Dump completed on 2017-12-09 7:51:11