a:15:{s:8:"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:9:"connexion";s:0:"";s:5:"titre";s:11:"titre, lang";s:8:"id_table";s:8:"articles";}s:13:"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:9:"connexion";s:0:"";s:5:"titre";s:0:"";s:8:"id_table";s:13:"mots_articles";}s:16:"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:9:"connexion";s:0:"";s:5:"titre";s:0:"";s:8:"id_table";s:16:"auteurs_articles";}s:15:"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:9:"connexion";s:0:"";s:5:"titre";s:0:"";s:8:"id_table";s:15:"documents_liens";}s:4:"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:9:"connexion";s:0:"";s:5:"titre";s:17:"titre, '' AS lang";s:8:"id_table";s:4:"mots";}s:9:"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:9:"connexion";s:0:"";s:5:"titre";s:11:"titre, lang";s:8:"id_table";s:9:"rubriques";}s:15:"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:9:"connexion";s:0:"";s:5:"titre";s:5:"titre";s:8:"id_table";s:15:"syndic_articles";}s:6:"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:9:"connexion";s:0:"";s:5:"titre";s:29:"nom_site AS titre, '' AS lang";s:8:"id_table";s:6:"syndic";}s:7:"auteurs";a:6:{s:5:"field";a:24:{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:9:"webmestre";s:33:"varchar(3) NOT NULL DEFAULT 'non'";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:9:"connexion";s:0:"";s:5:"titre";s:24:"nom AS titre, '' AS lang";}s:9:"documents";a:7:{s:5:"field";a:17:{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:13:"text NOT NULL";s:6:"taille";s:23:"bigint(20) DEFAULT NULL";s:7:"largeur";s:20:"int(11) DEFAULT NULL";s:7:"hauteur";s:20:"int(11) DEFAULT NULL";s:4:"mode";s:39:"varchar(10) 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:6:"statut";s:32:"varchar(10) NOT NULL DEFAULT '0'";s:16:"date_publication";s:47:"datetime NOT NULL DEFAULT '0000-00-00 00:00:00'";s:5:"brise";s:22:"tinyint(4) DEFAULT '0'";s:7:"credits";s:32:"varchar(255) NOT NULL DEFAULT ''";}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:9:"connexion";s:0:"";s:5:"titre";s:36:"titre, fichier AS surnom, '' AS lang";s:8:"id_table";s:9:"documents";}s:15:"types_documents";a:6:{s:5:"field";a:8:{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:5:"media";s:35:"varchar(10) NOT NULL DEFAULT 'file'";}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:9:"connexion";s:0:"";s:5:"titre";s:5:"titre";s:8:"id_table";s:15:"types_documents";}s:14:"mots_documents";a:5:{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:9:"connexion";s:0:"";s:5:"titre";s:0:"";}s:6:"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:9:"connexion";s:0:"";s:5:"titre";s:12:"titre , lang";s:8:"id_table";s:6:"breves";}s:8:"referers";a:5:{s:5:"field";a:7:{s:11:"referer_md5";s:28:"bigint(20) unsigned NOT NULL";s:4:"date";s:13:"date NOT NULL";s:7:"referer";s:25:"varchar(255) DEFAULT NULL";s:7:"visites";s:25:"int(10) unsigned NOT NULL";s:3:"maj";s:72:"timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP";s:14:"visites_veille";s:37:"int(10) unsigned NOT NULL DEFAULT '0'";s:12:"visites_jour";s:37:"int(10) unsigned NOT NULL DEFAULT '0'";}s:3:"key";a:1:{s:11:"PRIMARY KEY";s:11:"referer_md5";}s:5:"table";s:13:"spip_referers";s:9:"connexion";s:0:"";s:5:"titre";s:0:"";}s:5:"forum";a:6:{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(40) 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:9:"connexion";s:0:"";s:5:"titre";s:17:"titre, '' AS lang";}}