a:17:{s:11:"spip_breves";a:7:{s:5:"field";a:12:{s:8:"id_breve";s:34:"bigint(21) NOT NULL auto_increment";s:10:"date_heure";s:47:"datetime NOT NULL default '0000-00-00 00:00:00'";s:5:"titre";s:13:"text NOT NULL";s:5:"texte";s:17:"longtext NOT NULL";s:10:"lien_titre";s:13:"text NOT NULL";s:8:"lien_url";s:13:"text NOT NULL";s:6:"statut";s:31:"varchar(6) NOT NULL default '0'";s:11:"id_rubrique";s:31:"bigint(21) NOT NULL default '0'";s:4:"lang";s:31:"varchar(10) NOT NULL default ''";s:14:"langue_choisie";s:24:"varchar(3) default 'non'";s:3:"maj";s:72:"timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP";s:5:"extra";s:8:"longtext";}s:3:"key";a:2:{s:11:"PRIMARY KEY";s:8:"id_breve";s:15:"KEY id_rubrique";s:11:"id_rubrique";}s:4:"join";a:2:{s:8:"id_breve";s:8:"id_breve";s:11:"id_rubrique";s:11:"id_rubrique";}s:5:"table";s:11:"spip_breves";s:8:"id_table";s:6:"breves";s:9:"connexion";s:0:"";s:5:"titre";s:12:"titre , lang";}s:13:"spip_articles";a:7:{s:5:"field";a:27:{s:10:"id_article";s:34:"bigint(21) NOT NULL auto_increment";s:8:"surtitre";s:13:"text NOT NULL";s:5:"titre";s:13:"text NOT NULL";s:9:"soustitre";s:13:"text NOT NULL";s:11:"id_rubrique";s:31:"bigint(21) NOT NULL default '0'";s:10:"descriptif";s:13:"text NOT NULL";s:5:"chapo";s:19:"mediumtext NOT NULL";s:5:"texte";s:17:"longtext NOT NULL";s:2:"ps";s:19:"mediumtext NOT NULL";s:4:"date";s:47:"datetime NOT NULL default '0000-00-00 00:00:00'";s:6:"statut";s:32:"varchar(10) NOT NULL default '0'";s:10:"id_secteur";s:31:"bigint(21) NOT NULL default '0'";s:3:"maj";s:72:"timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP";s:6:"export";s:25:"varchar(10) default 'oui'";s:10:"date_redac";s:47:"datetime NOT NULL default '0000-00-00 00:00:00'";s:7:"visites";s:28:"int(11) NOT NULL default '0'";s:8:"referers";s:28:"int(11) NOT NULL default '0'";s:10:"popularite";s:27:"double NOT NULL default '0'";s:14:"accepter_forum";s:27:"char(3) NOT NULL default ''";s:10:"date_modif";s:47:"datetime NOT NULL default '0000-00-00 00:00:00'";s:4:"lang";s:31:"varchar(10) NOT NULL default ''";s:14:"langue_choisie";s:24:"varchar(3) default 'non'";s:7:"id_trad";s:31:"bigint(21) NOT NULL default '0'";s:5:"extra";s:8:"longtext";s:10:"id_version";s:37:"int(10) unsigned NOT NULL default '0'";s:8:"nom_site";s:17:"tinytext NOT NULL";s:8:"url_site";s:32:"varchar(255) NOT NULL default ''";}s:3:"key";a:6:{s:11:"PRIMARY KEY";s:10:"id_article";s:15:"KEY id_rubrique";s:11:"id_rubrique";s:14:"KEY id_secteur";s:10:"id_secteur";s:11:"KEY id_trad";s:7:"id_trad";s:8:"KEY lang";s:4:"lang";s:10:"KEY statut";s:11:"statut,date";}s:4:"join";a:2:{s:10:"id_article";s:10:"id_article";s:11:"id_rubrique";s:11:"id_rubrique";}s:5:"table";s:13:"spip_articles";s:8:"id_table";s:8:"articles";s:9:"connexion";s:0:"";s:5:"titre";s:11:"titre, lang";}s:10:"spip_forum";a:7:{s:5:"field";a:20:{s:8:"id_forum";s:34:"bigint(21) NOT NULL auto_increment";s:9:"id_parent";s:31:"bigint(21) NOT NULL default '0'";s:9:"id_thread";s:31:"bigint(21) NOT NULL default '0'";s:11:"id_rubrique";s:31:"bigint(21) NOT NULL default '0'";s:10:"id_article";s:31:"bigint(21) NOT NULL default '0'";s:8:"id_breve";s:31:"bigint(21) NOT NULL default '0'";s:10:"date_heure";s:47:"datetime NOT NULL default '0000-00-00 00:00:00'";s:11:"date_thread";s:47:"datetime NOT NULL default '0000-00-00 00:00:00'";s:5:"titre";s:13:"text NOT NULL";s:5:"texte";s:19:"mediumtext NOT NULL";s:6:"auteur";s:13:"text NOT NULL";s:12:"email_auteur";s:13:"text NOT NULL";s:8:"nom_site";s:13:"text NOT NULL";s:8:"url_site";s:13:"text NOT NULL";s:6:"statut";s:31:"varchar(8) NOT NULL default '0'";s:2:"ip";s:31:"varchar(16) NOT NULL default ''";s:3:"maj";s:72:"timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP";s:9:"id_auteur";s:31:"bigint(20) NOT NULL default '0'";s:10:"id_message";s:31:"bigint(21) NOT NULL default '0'";s:9:"id_syndic";s:31:"bigint(21) NOT NULL default '0'";}s:3:"key";a:5:{s:11:"PRIMARY KEY";s:8:"id_forum";s:13:"KEY id_auteur";s:9:"id_auteur";s:13:"KEY id_parent";s:9:"id_parent";s:13:"KEY id_thread";s:9:"id_thread";s:11:"KEY optimal";s:69:"statut,id_parent,id_article,date_heure,id_breve,id_syndic,id_rubrique";}s:4:"join";a:7:{s:8:"id_forum";s:8:"id_forum";s:9:"id_parent";s:9:"id_parent";s:10:"id_article";s:10:"id_article";s:8:"id_breve";s:8:"id_breve";s:10:"id_message";s:10:"id_message";s:9:"id_syndic";s:9:"id_syndic";s:11:"id_rubrique";s:11:"id_rubrique";}s:5:"table";s:10:"spip_forum";s:8:"id_table";s:5:"forum";s:9:"connexion";s:0:"";s:5:"titre";s:0:"";}s:20:"spip_syndic_articles";a:7:{s:5:"field";a:13:{s:17:"id_syndic_article";s:34:"bigint(21) NOT NULL auto_increment";s:9:"id_syndic";s:31:"bigint(21) NOT NULL default '0'";s:5:"titre";s:13:"text NOT NULL";s:3:"url";s:32:"varchar(255) NOT NULL default ''";s:4:"date";s:47:"datetime NOT NULL default '0000-00-00 00:00:00'";s:10:"lesauteurs";s:13:"text NOT NULL";s:3:"maj";s:72:"timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP";s:6:"statut";s:32:"varchar(10) NOT NULL default '0'";s:10:"descriptif";s:13:"text NOT NULL";s:4:"lang";s:31:"varchar(10) NOT NULL default ''";s:10:"url_source";s:17:"tinytext NOT NULL";s:6:"source";s:17:"tinytext NOT NULL";s:4:"tags";s:13:"text NOT NULL";}s:3:"key";a:4:{s:11:"PRIMARY KEY";s:17:"id_syndic_article";s:13:"KEY id_syndic";s:9:"id_syndic";s:10:"KEY statut";s:6:"statut";s:7:"KEY url";s:3:"url";}s:4:"join";a:2:{s:17:"id_syndic_article";s:17:"id_syndic_article";s:9:"id_syndic";s:9:"id_syndic";}s:5:"table";s:20:"spip_syndic_articles";s:8:"id_table";s:15:"syndic_articles";s:9:"connexion";s:0:"";s:5:"titre";s:0:"";}s:11:"spip_syndic";a:7:{s:5:"field";a:18:{s:9:"id_syndic";s:34:"bigint(21) NOT NULL auto_increment";s:11:"id_rubrique";s:31:"bigint(21) NOT NULL default '0'";s:10:"id_secteur";s:31:"bigint(21) NOT NULL default '0'";s:8:"nom_site";s:13:"text NOT NULL";s:8:"url_site";s:13:"text NOT NULL";s:10:"url_syndic";s:13:"text NOT NULL";s:10:"descriptif";s:13:"text NOT NULL";s:3:"maj";s:72:"timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP";s:11:"syndication";s:30:"varchar(3) NOT NULL default ''";s:6:"statut";s:32:"varchar(10) NOT NULL default '0'";s:4:"date";s:47:"datetime NOT NULL default '0000-00-00 00:00:00'";s:11:"date_syndic";s:47:"datetime NOT NULL default '0000-00-00 00:00:00'";s:10:"date_index";s:47:"datetime NOT NULL default '0000-00-00 00:00:00'";s:5:"extra";s:8:"longtext";s:10:"moderation";s:24:"varchar(3) default 'non'";s:6:"miroir";s:24:"varchar(3) default 'non'";s:5:"oubli";s:24:"varchar(3) default 'non'";s:6:"resume";s:24:"varchar(3) default 'oui'";}s:3:"key";a:4:{s:11:"PRIMARY KEY";s:9:"id_syndic";s:15:"KEY id_rubrique";s:11:"id_rubrique";s:14:"KEY id_secteur";s:10:"id_secteur";s:10:"KEY statut";s:18:"statut,date_syndic";}s:4:"join";a:2:{s:9:"id_syndic";s:9:"id_syndic";s:11:"id_rubrique";s:11:"id_rubrique";}s:5:"table";s:11:"spip_syndic";s:8:"id_table";s:6:"syndic";s:9:"connexion";s:0:"";s:5:"titre";s:29:"nom_site AS titre, '' AS lang";}s:14:"spip_rubriques";a:6:{s:5:"field";a:16:{s:11:"id_rubrique";s:34:"bigint(21) NOT NULL auto_increment";s:9:"id_parent";s:31:"bigint(21) NOT NULL default '0'";s:5:"titre";s:13:"text NOT NULL";s:10:"descriptif";s:13:"text NOT NULL";s:5:"texte";s:17:"longtext NOT NULL";s:10:"id_secteur";s:31:"bigint(21) NOT NULL default '0'";s:3:"maj";s:72:"timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP";s:6:"export";s:25:"varchar(10) default 'oui'";s:9:"id_import";s:22:"bigint(20) default '0'";s:6:"statut";s:32:"varchar(10) NOT NULL default '0'";s:4:"date";s:47:"datetime NOT NULL default '0000-00-00 00:00:00'";s:4:"lang";s:31:"varchar(10) NOT NULL default ''";s:14:"langue_choisie";s:24:"varchar(3) default 'non'";s:5:"extra";s:8:"longtext";s:10:"statut_tmp";s:32:"varchar(10) NOT NULL default '0'";s:8:"date_tmp";s:47:"datetime NOT NULL default '0000-00-00 00:00:00'";}s:3:"key";a:3:{s:11:"PRIMARY KEY";s:11:"id_rubrique";s:8:"KEY lang";s:4:"lang";s:13:"KEY id_parent";s:9:"id_parent";}s:5:"table";s:14:"spip_rubriques";s:8:"id_table";s:9:"rubriques";s:9:"connexion";s:0:"";s:5:"titre";s:11:"titre, lang";}s:9:"spip_mots";a:6:{s:5:"field";a:8:{s:6:"id_mot";s:34:"bigint(21) NOT NULL auto_increment";s:5:"titre";s:13:"text NOT NULL";s:10:"descriptif";s:13:"text NOT NULL";s:5:"texte";s:17:"longtext NOT NULL";s:9:"id_groupe";s:31:"bigint(21) NOT NULL default '0'";s:4:"type";s:13:"text NOT NULL";s:5:"extra";s:8:"longtext";s:3:"maj";s:72:"timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP";}s:3:"key";a:1:{s:11:"PRIMARY KEY";s:6:"id_mot";}s:5:"table";s:9:"spip_mots";s:8:"id_table";s:4:"mots";s:9:"connexion";s:0:"";s:5:"titre";s:17:"titre, '' AS lang";}s:12:"spip_auteurs";a:7:{s:5:"field";a:23:{s:9:"id_auteur";s:34:"bigint(21) NOT NULL auto_increment";s:3:"nom";s:13:"text NOT NULL";s:3:"bio";s:13:"text NOT NULL";s:5:"email";s:17:"tinytext NOT NULL";s:8:"nom_site";s:17:"tinytext NOT NULL";s:8:"url_site";s:13:"text NOT NULL";s:5:"login";s:61:"varchar(255) character set utf8 collate utf8_bin default NULL";s:4:"pass";s:17:"tinytext NOT NULL";s:7:"low_sec";s:17:"tinytext NOT NULL";s:6:"statut";s:33:"varchar(255) NOT NULL default '0'";s:3:"maj";s:72:"timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP";s:3:"pgp";s:13:"text NOT NULL";s:6:"htpass";s:17:"tinytext NOT NULL";s:8:"en_ligne";s:47:"datetime NOT NULL default '0000-00-00 00:00:00'";s:8:"imessage";s:23:"varchar(3) default NULL";s:10:"messagerie";s:23:"varchar(3) default NULL";s:11:"alea_actuel";s:8:"tinytext";s:10:"alea_futur";s:8:"tinytext";s:5:"prefs";s:8:"tinytext";s:12:"cookie_oubli";s:8:"tinytext";s:6:"source";s:35:"varchar(10) NOT NULL default 'spip'";s:4:"lang";s:31:"varchar(10) NOT NULL default ''";s:5:"extra";s:8:"longtext";}s:3:"key";a:4:{s:11:"PRIMARY KEY";s:9:"id_auteur";s:9:"KEY login";s:5:"login";s:10:"KEY statut";s:6:"statut";s:12:"KEY en_ligne";s:8:"en_ligne";}s:4:"join";a:2:{s:9:"id_auteur";s:9:"id_auteur";s:5:"login";s:5:"login";}s:5:"table";s:12:"spip_auteurs";s:8:"id_table";s:7:"auteurs";s:9:"connexion";s:0:"";s:5:"titre";s:24:"nom AS titre, '' AS lang";}s:18:"spip_mots_articles";a:6:{s:5:"field";a:2:{s:6:"id_mot";s:31:"bigint(21) NOT NULL default '0'";s:10:"id_article";s:31:"bigint(21) NOT NULL default '0'";}s:3:"key";a:2:{s:11:"PRIMARY KEY";s:17:"id_article,id_mot";s:10:"KEY id_mot";s:6:"id_mot";}s:5:"table";s:18:"spip_mots_articles";s:8:"id_table";s:13:"mots_articles";s:9:"connexion";s:0:"";s:5:"titre";s:0:"";}s:21:"spip_auteurs_articles";a:6:{s:5:"field";a:2:{s:9:"id_auteur";s:31:"bigint(21) NOT NULL default '0'";s:10:"id_article";s:31:"bigint(21) NOT NULL default '0'";}s:3:"key";a:2:{s:11:"PRIMARY KEY";s:20:"id_auteur,id_article";s:14:"KEY id_article";s:10:"id_article";}s:5:"table";s:21:"spip_auteurs_articles";s:8:"id_table";s:16:"auteurs_articles";s:9:"connexion";s:0:"";s:5:"titre";s:0:"";}s:14:"spip_documents";a:7:{s:5:"field";a:13:{s:11:"id_document";s:34:"bigint(21) NOT NULL auto_increment";s:11:"id_vignette";s:31:"bigint(21) NOT NULL default '0'";s:9:"extension";s:31:"varchar(10) NOT NULL default ''";s:5:"titre";s:13:"text NOT NULL";s:4:"date";s:47:"datetime NOT NULL default '0000-00-00 00:00:00'";s:10:"descriptif";s:13:"text NOT NULL";s:7:"fichier";s:32:"varchar(255) NOT NULL default ''";s:6:"taille";s:20:"int(11) default NULL";s:7:"largeur";s:20:"int(11) default NULL";s:7:"hauteur";s:20:"int(11) default NULL";s:4:"mode";s:63:"enum('vignette','image','document') NOT NULL default 'document'";s:7:"distant";s:24:"varchar(3) default 'non'";s:3:"maj";s:72:"timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP";}s:3:"key";a:4:{s:11:"PRIMARY KEY";s:11:"id_document";s:15:"KEY id_vignette";s:11:"id_vignette";s:8:"KEY mode";s:4:"mode";s:13:"KEY extension";s:9:"extension";}s:4:"join";a:2:{s:11:"id_document";s:11:"id_document";s:9:"extension";s:9:"extension";}s:5:"table";s:14:"spip_documents";s:8:"id_table";s:9:"documents";s:9:"connexion";s:0:"";s:5:"titre";s:36:"titre, fichier AS surnom, '' AS lang";}s:20:"spip_documents_liens";a:6:{s:5:"field";a:4:{s:11:"id_document";s:31:"bigint(21) NOT NULL default '0'";s:8:"id_objet";s:31:"bigint(21) NOT NULL default '0'";s:5:"objet";s:31:"varchar(25) NOT NULL default ''";s:2:"vu";s:40:"enum('non','oui') NOT NULL default 'non'";}s:3:"key";a:2:{s:11:"PRIMARY KEY";s:26:"id_document,id_objet,objet";s:15:"KEY id_document";s:11:"id_document";}s:5:"table";s:20:"spip_documents_liens";s:8:"id_table";s:15:"documents_liens";s:9:"connexion";s:0:"";s:5:"titre";s:0:"";}s:19:"spip_mots_documents";a:6:{s:5:"field";a:2:{s:6:"id_mot";s:31:"bigint(21) NOT NULL default '0'";s:11:"id_document";s:31:"bigint(21) NOT NULL default '0'";}s:3:"key";a:2:{s:11:"PRIMARY KEY";s:18:"id_document,id_mot";s:10:"KEY id_mot";s:6:"id_mot";}s:5:"table";s:19:"spip_mots_documents";s:8:"id_table";s:14:"mots_documents";s:9:"connexion";s:0:"";s:5:"titre";s:0:"";}s:20:"spip_types_documents";a:6:{s:5:"field";a:7:{s:9:"extension";s:31:"varchar(10) NOT NULL default ''";s:5:"titre";s:13:"text NOT NULL";s:10:"descriptif";s:13:"text NOT NULL";s:9:"mime_type";s:32:"varchar(100) NOT NULL default ''";s:6:"inclus";s:50:"enum('non','image','embed') NOT NULL default 'non'";s:6:"upload";s:40:"enum('oui','non') NOT NULL default 'oui'";s:3:"maj";s:72:"timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP";}s:3:"key";a:2:{s:11:"PRIMARY KEY";s:9:"extension";s:10:"KEY inclus";s:6:"inclus";}s:5:"table";s:20:"spip_types_documents";s:8:"id_table";s:15:"types_documents";s:9:"connexion";s:0:"";s:5:"titre";s:0:"";}s:16:"spip_mots_breves";a:6:{s:5:"field";a:2:{s:6:"id_mot";s:31:"bigint(21) NOT NULL default '0'";s:8:"id_breve";s:31:"bigint(21) NOT NULL default '0'";}s:3:"key";a:2:{s:11:"PRIMARY KEY";s:15:"id_breve,id_mot";s:10:"KEY id_mot";s:6:"id_mot";}s:5:"table";s:16:"spip_mots_breves";s:8:"id_table";s:11:"mots_breves";s:9:"connexion";s:0:"";s:5:"titre";s:0:"";}s:15:"spip_mots_forum";a:6:{s:5:"field";a:2:{s:6:"id_mot";s:31:"bigint(21) NOT NULL default '0'";s:8:"id_forum";s:31:"bigint(21) NOT NULL default '0'";}s:3:"key";a:2:{s:11:"PRIMARY KEY";s:15:"id_forum,id_mot";s:10:"KEY id_mot";s:6:"id_mot";}s:5:"table";s:15:"spip_mots_forum";s:8:"id_table";s:10:"mots_forum";s:9:"connexion";s:0:"";s:5:"titre";s:0:"";}s:19:"spip_mots_rubriques";a:6:{s:5:"field";a:2:{s:6:"id_mot";s:31:"bigint(21) NOT NULL default '0'";s:11:"id_rubrique";s:31:"bigint(21) NOT NULL default '0'";}s:3:"key";a:2:{s:11:"PRIMARY KEY";s:18:"id_rubrique,id_mot";s:10:"KEY id_mot";s:6:"id_mot";}s:5:"table";s:19:"spip_mots_rubriques";s:8:"id_table";s:14:"mots_rubriques";s:9:"connexion";s:0:"";s:5:"titre";s:0:"";}}