-- phpMyAdmin SQL Dump
-- version 3.5.2.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Sep 18, 2014 at 09:54 AM
-- Server version: 5.1.73-1-log
-- PHP Version: 5.3.3-7+squeeze19

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `TEST`
--

-- --------------------------------------------------------

--
-- Table structure for table `spip_articles`
--

CREATE TABLE IF NOT EXISTS `spip_articles` (
  `id_article` BIGINT(21) NOT NULL AUTO_INCREMENT,
  `surtitre` text NOT NULL,
  `titre` text NOT NULL,
  `soustitre` text NOT NULL,
  `id_rubrique` BIGINT(21) NOT NULL DEFAULT '0',
  `descriptif` text NOT NULL,
  `chapo` mediumtext NOT NULL,
  `texte` longtext NOT NULL,
  `ps` mediumtext NOT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `statut` VARCHAR(10) NOT NULL DEFAULT '0',
  `id_secteur` BIGINT(21) NOT NULL DEFAULT '0',
  `maj` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `export` VARCHAR(10) DEFAULT 'oui',
  `date_redac` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `visites` INT(11) NOT NULL DEFAULT '0',
  `referers` INT(11) NOT NULL DEFAULT '0',
  `popularite` DOUBLE NOT NULL DEFAULT '0',
  `accepter_forum` CHAR(3) NOT NULL DEFAULT '',
  `date_modif` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `lang` VARCHAR(10) NOT NULL DEFAULT '',
  `langue_choisie` VARCHAR(3) DEFAULT 'non',
  `id_trad` BIGINT(21) NOT NULL DEFAULT '0',
  `extra` longtext,
  `id_version` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `nom_site` tinytext NOT NULL,
  `url_site` VARCHAR(255) NOT NULL DEFAULT '',
  `telephone` text NOT NULL,
  `latitude` text NOT NULL,
  `longitude` text NOT NULL,
  `prix` VARCHAR(250) NOT NULL DEFAULT '',
  `chambres` VARCHAR(250) NOT NULL DEFAULT '',
  `restaurant` VARCHAR(250) NOT NULL DEFAULT '',
  `importationimage` VARCHAR(250) NOT NULL DEFAULT '',
  `accepter_note` CHAR(3) NOT NULL DEFAULT '',
  `qui` text NOT NULL,
  `comment` text NOT NULL,
  `format_contenu` text NOT NULL,
  `transport` text NOT NULL,
  `was_nun` text NOT NULL,
  `conseil` text NOT NULL,
  `etoiles` VARCHAR(250) NOT NULL DEFAULT '',
  `resahotelbooking` VARCHAR(250) NOT NULL DEFAULT '',
  `adresse` VARCHAR(250) NOT NULL DEFAULT '',
  `horaires2` text NOT NULL,
  `amazon` text NOT NULL,
  `virtuel` VARCHAR(255) NOT NULL DEFAULT '',
  `microblog` VARCHAR(140) NOT NULL DEFAULT '',
  PRIMARY KEY (`id_article`),
  KEY `id_rubrique` (`id_rubrique`),
  KEY `id_secteur` (`id_secteur`),
  KEY `id_trad` (`id_trad`),
  KEY `lang` (`lang`),
  KEY `statut` (`statut`,`date`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=702657 ;

-- --------------------------------------------------------

--
-- Table structure for table `spip_auteurs`
--

CREATE TABLE IF NOT EXISTS `spip_auteurs` (
  `id_auteur` BIGINT(21) NOT NULL AUTO_INCREMENT,
  `nom` text NOT NULL,
  `bio` text NOT NULL,
  `email` tinytext NOT NULL,
  `nom_site` tinytext NOT NULL,
  `url_site` text NOT NULL,
  `login` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `pass` tinytext NOT NULL,
  `low_sec` tinytext NOT NULL,
  `statut` VARCHAR(255) NOT NULL DEFAULT '0',
  `maj` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `pgp` text NOT NULL,
  `htpass` tinytext NOT NULL,
  `en_ligne` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `imessage` VARCHAR(3) DEFAULT NULL,
  `messagerie` VARCHAR(3) DEFAULT NULL,
  `alea_actuel` tinytext,
  `alea_futur` tinytext,
  `prefs` tinytext,
  `cookie_oubli` tinytext,
  `source` VARCHAR(10) NOT NULL DEFAULT 'spip',
  `lang` VARCHAR(10) NOT NULL DEFAULT '',
  `extra` longtext,
  `analytics` VARCHAR(250) NOT NULL DEFAULT '',
  `webmestre` VARCHAR(3) NOT NULL DEFAULT 'non',
  PRIMARY KEY (`id_auteur`),
  KEY `login` (`login`),
  KEY `statut` (`statut`),
  KEY `en_ligne` (`en_ligne`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=166 ;

-- --------------------------------------------------------

--
-- Table structure for table `spip_auteurs_liens`
--

CREATE TABLE IF NOT EXISTS `spip_auteurs_liens` (
  `id_auteur` BIGINT(21) NOT NULL DEFAULT '0',
  `id_objet` BIGINT(21) NOT NULL DEFAULT '0',
  `objet` VARCHAR(25) NOT NULL DEFAULT '',
  `vu` VARCHAR(6) NOT NULL DEFAULT 'non',
  PRIMARY KEY (`id_auteur`,`id_objet`,`objet`),
  KEY `id_auteur` (`id_auteur`),
  KEY `id_objet` (`id_objet`),
  KEY `objet` (`objet`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `spip_breves`
--

CREATE TABLE IF NOT EXISTS `spip_breves` (
  `id_breve` BIGINT(21) NOT NULL AUTO_INCREMENT,
  `date_heure` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `titre` text NOT NULL,
  `texte` longtext NOT NULL,
  `lien_titre` text NOT NULL,
  `lien_url` text NOT NULL,
  `statut` VARCHAR(6) NOT NULL DEFAULT '0',
  `id_rubrique` BIGINT(21) NOT NULL DEFAULT '0',
  `lang` VARCHAR(10) NOT NULL DEFAULT '',
  `langue_choisie` VARCHAR(3) DEFAULT 'non',
  `maj` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `extra` longtext,
  PRIMARY KEY (`id_breve`),
  KEY `id_rubrique` (`id_rubrique`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--
-- Table structure for table `spip_cartodb_lookup`
--

CREATE TABLE IF NOT EXISTS `spip_cartodb_lookup` (
  `cartodb_id` INT(11) NOT NULL,
  `auteur_id` INT(11) NOT NULL,
  `article_id` INT(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `spip_debats`
--

CREATE TABLE IF NOT EXISTS `spip_debats` (
  `id_pratique` BIGINT(21) NOT NULL AUTO_INCREMENT,
  `id_rubrique` BIGINT(21) NOT NULL DEFAULT '0',
  `id_secteur` BIGINT(21) NOT NULL DEFAULT '0',
  `titre` text NOT NULL,
  `accroche` text,
  `introduction` text,
  `questions` text NOT NULL,
  `appel` mediumtext NOT NULL,
  `date_publication` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `statut` VARCHAR(20) NOT NULL DEFAULT '0',
  `lang` VARCHAR(10) NOT NULL DEFAULT '',
  `langue_choisie` VARCHAR(3) DEFAULT 'non',
  `id_trad` BIGINT(21) NOT NULL DEFAULT '0',
  `maj` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_pratique`),
  KEY `id_rubrique` (`id_rubrique`),
  KEY `id_secteur` (`id_secteur`),
  KEY `lang` (`lang`),
  KEY `id_trad` (`id_trad`),
  KEY `statut` (`statut`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `spip_debats_liens`
--

CREATE TABLE IF NOT EXISTS `spip_debats_liens` (
  `id_pratique` BIGINT(21) NOT NULL DEFAULT '0',
  `id_objet` BIGINT(21) NOT NULL DEFAULT '0',
  `objet` VARCHAR(25) NOT NULL DEFAULT '',
  `vu` VARCHAR(6) NOT NULL DEFAULT 'non',
  PRIMARY KEY (`id_pratique`,`id_objet`,`objet`),
  KEY `id_pratique` (`id_pratique`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `spip_depots`
--

CREATE TABLE IF NOT EXISTS `spip_depots` (
  `id_depot` BIGINT(21) NOT NULL AUTO_INCREMENT,
  `titre` text NOT NULL,
  `descriptif` text NOT NULL,
  `type` VARCHAR(10) NOT NULL DEFAULT '',
  `url_serveur` VARCHAR(255) NOT NULL DEFAULT '',
  `url_brouteur` VARCHAR(255) NOT NULL DEFAULT '',
  `url_archives` VARCHAR(255) NOT NULL DEFAULT '',
  `url_commits` VARCHAR(255) NOT NULL DEFAULT '',
  `xml_paquets` VARCHAR(255) NOT NULL DEFAULT '',
  `sha_paquets` VARCHAR(40) NOT NULL DEFAULT '',
  `nbr_paquets` INT(11) NOT NULL DEFAULT '0',
  `nbr_plugins` INT(11) NOT NULL DEFAULT '0',
  `nbr_autres` INT(11) NOT NULL DEFAULT '0',
  `maj` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_depot`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--
-- Table structure for table `spip_depots_plugins`
--

CREATE TABLE IF NOT EXISTS `spip_depots_plugins` (
  `id_depot` BIGINT(21) NOT NULL,
  `id_plugin` BIGINT(21) NOT NULL,
  PRIMARY KEY (`id_depot`,`id_plugin`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `spip_documents`
--

CREATE TABLE IF NOT EXISTS `spip_documents` (
  `id_document` BIGINT(21) NOT NULL AUTO_INCREMENT,
  `id_vignette` BIGINT(21) NOT NULL DEFAULT '0',
  `extension` VARCHAR(10) NOT NULL DEFAULT '',
  `titre` text NOT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `descriptif` text NOT NULL,
  `fichier` text NOT NULL,
  `taille` BIGINT(20) DEFAULT NULL,
  `largeur` INT(11) DEFAULT NULL,
  `hauteur` INT(11) DEFAULT NULL,
  `mode` VARCHAR(10) NOT NULL DEFAULT 'document',
  `distant` VARCHAR(3) DEFAULT 'non',
  `maj` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `statut` VARCHAR(10) NOT NULL DEFAULT '0',
  `date_publication` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `brise` tinyint(4) DEFAULT '0',
  `credits` VARCHAR(255) NOT NULL DEFAULT '',
  `media` VARCHAR(10) NOT NULL DEFAULT 'file',
  PRIMARY KEY (`id_document`),
  KEY `id_vignette` (`id_vignette`),
  KEY `mode` (`mode`),
  KEY `extension` (`extension`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1661 ;

-- --------------------------------------------------------

--
-- Table structure for table `spip_documents_liens`
--

CREATE TABLE IF NOT EXISTS `spip_documents_liens` (
  `id_document` BIGINT(21) NOT NULL DEFAULT '0',
  `id_objet` BIGINT(21) NOT NULL DEFAULT '0',
  `objet` VARCHAR(25) NOT NULL DEFAULT '',
  `vu` enum('non','oui') NOT NULL DEFAULT 'non',
  PRIMARY KEY (`id_document`,`id_objet`,`objet`),
  KEY `id_document` (`id_document`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `spip_evenements`
--

CREATE TABLE IF NOT EXISTS `spip_evenements` (
  `id_evenement` BIGINT(21) NOT NULL AUTO_INCREMENT,
  `id_article` BIGINT(21) NOT NULL DEFAULT '0',
  `date_debut` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_fin` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `titre` text NOT NULL,
  `descriptif` text NOT NULL,
  `lieu` text NOT NULL,
  `adresse` text NOT NULL,
  `inscription` tinyint(1) NOT NULL DEFAULT '0',
  `places` INT(11) NOT NULL DEFAULT '0',
  `horaire` VARCHAR(3) NOT NULL DEFAULT 'oui',
  `id_evenement_source` BIGINT(21) NOT NULL,
  `maj` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `date_creation` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `statut` VARCHAR(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_evenement`),
  KEY `date_debut` (`date_debut`),
  KEY `date_fin` (`date_fin`),
  KEY `id_article` (`id_article`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

--
-- Table structure for table `spip_evenements_participants`
--

CREATE TABLE IF NOT EXISTS `spip_evenements_participants` (
  `id_evenement_participant` BIGINT(21) NOT NULL AUTO_INCREMENT,
  `id_evenement` BIGINT(21) NOT NULL DEFAULT '0',
  `id_auteur` BIGINT(21) NOT NULL DEFAULT '0',
  `nom` text NOT NULL,
  `email` tinytext NOT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `reponse` CHAR(3) NOT NULL DEFAULT '?',
  PRIMARY KEY (`id_evenement_participant`),
  KEY `id_auteur` (`id_auteur`),
  KEY `id_evenement` (`id_evenement`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `spip_fiches_liens`
--

CREATE TABLE IF NOT EXISTS `spip_fiches_liens` (
  `id_fiche` BIGINT(21) NOT NULL DEFAULT '0',
  `id_objet` BIGINT(21) NOT NULL DEFAULT '0',
  `objet` VARCHAR(25) NOT NULL DEFAULT '',
  `vu` VARCHAR(6) NOT NULL DEFAULT 'non',
  PRIMARY KEY (`id_fiche`,`id_objet`,`objet`),
  KEY `id_fiche` (`id_fiche`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `spip_forum`
--

CREATE TABLE IF NOT EXISTS `spip_forum` (
  `id_forum` BIGINT(21) NOT NULL AUTO_INCREMENT,
  `id_objet` BIGINT(21) NOT NULL DEFAULT '0',
  `objet` VARCHAR(25) NOT NULL DEFAULT '',
  `id_parent` BIGINT(21) NOT NULL DEFAULT '0',
  `id_thread` BIGINT(21) NOT NULL DEFAULT '0',
  `date_heure` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_thread` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `titre` text NOT NULL,
  `texte` mediumtext NOT NULL,
  `auteur` text NOT NULL,
  `email_auteur` text NOT NULL,
  `nom_site` text NOT NULL,
  `url_site` text NOT NULL,
  `statut` VARCHAR(8) NOT NULL DEFAULT '0',
  `ip` VARCHAR(40) NOT NULL DEFAULT '',
  `maj` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `id_auteur` BIGINT(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_forum`),
  KEY `id_auteur` (`id_auteur`),
  KEY `id_parent` (`id_parent`),
  KEY `id_thread` (`id_thread`),
  KEY `optimal` (`statut`,`id_parent`,`id_objet`,`objet`,`date_heure`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=550 ;

-- --------------------------------------------------------

--
-- Table structure for table `spip_gis`
--

CREATE TABLE IF NOT EXISTS `spip_gis` (
  `id_gis` BIGINT(21) NOT NULL AUTO_INCREMENT,
  `titre` text NOT NULL,
  `descriptif` text NOT NULL,
  `lat` DOUBLE DEFAULT NULL,
  `lon` DOUBLE DEFAULT NULL,
  `zoom` tinyint(4) DEFAULT NULL,
  `adresse` text NOT NULL,
  `pays` text NOT NULL,
  `code_pays` VARCHAR(255) NOT NULL DEFAULT '',
  `region` text NOT NULL,
  `departement` text NOT NULL,
  `ville` text NOT NULL,
  `code_postal` VARCHAR(255) NOT NULL DEFAULT '',
  `checkbox_1` text NOT NULL,
  PRIMARY KEY (`id_gis`),
  KEY `lat` (`lat`),
  KEY `lon` (`lon`),
  KEY `pays` (`pays`(333)),
  KEY `code_pays` (`code_pays`),
  KEY `region` (`region`(333)),
  KEY `ville` (`ville`(333)),
  KEY `code_postal` (`code_postal`),
  KEY `departement` (`departement`(333))
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=147 ;

-- --------------------------------------------------------

--
-- Table structure for table `spip_gis_liens`
--

CREATE TABLE IF NOT EXISTS `spip_gis_liens` (
  `id_gis` BIGINT(21) NOT NULL,
  `objet` VARCHAR(25) NOT NULL DEFAULT '',
  `id_objet` BIGINT(21) NOT NULL,
  PRIMARY KEY (`id_gis`,`id_objet`,`objet`),
  KEY `id_objet` (`id_gis`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `spip_groupes_mots`
--

CREATE TABLE IF NOT EXISTS `spip_groupes_mots` (
  `id_groupe` BIGINT(21) NOT NULL AUTO_INCREMENT,
  `titre` text NOT NULL,
  `descriptif` text NOT NULL,
  `texte` longtext NOT NULL,
  `unseul` VARCHAR(3) NOT NULL DEFAULT '',
  `obligatoire` VARCHAR(3) NOT NULL DEFAULT '',
  `tables_liees` text NOT NULL,
  `minirezo` VARCHAR(3) NOT NULL DEFAULT '',
  `comite` VARCHAR(3) NOT NULL DEFAULT '',
  `forum` VARCHAR(3) NOT NULL DEFAULT '',
  `maj` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_groupe`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=62 ;

-- --------------------------------------------------------

--
-- Table structure for table `spip_jobs`
--

CREATE TABLE IF NOT EXISTS `spip_jobs` (
  `id_job` BIGINT(21) NOT NULL AUTO_INCREMENT,
  `descriptif` text NOT NULL,
  `fonction` VARCHAR(255) NOT NULL,
  `args` longblob NOT NULL,
  `md5args` CHAR(32) NOT NULL DEFAULT '',
  `inclure` VARCHAR(255) NOT NULL,
  `priorite` SMALLINT(6) NOT NULL DEFAULT '0',
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `status` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id_job`),
  KEY `date` (`date`),
  KEY `status` (`status`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=979224 ;

-- --------------------------------------------------------

--
-- Table structure for table `spip_jobs_liens`
--

CREATE TABLE IF NOT EXISTS `spip_jobs_liens` (
  `id_job` BIGINT(21) NOT NULL DEFAULT '0',
  `id_objet` BIGINT(21) NOT NULL DEFAULT '0',
  `objet` VARCHAR(25) NOT NULL DEFAULT '',
  PRIMARY KEY (`id_job`,`id_objet`,`objet`),
  KEY `id_job` (`id_job`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `spip_messages`
--

CREATE TABLE IF NOT EXISTS `spip_messages` (
  `id_message` BIGINT(21) NOT NULL AUTO_INCREMENT,
  `titre` text NOT NULL,
  `texte` longtext NOT NULL,
  `type` VARCHAR(6) NOT NULL DEFAULT '',
  `date_heure` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_fin` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `rv` VARCHAR(3) NOT NULL DEFAULT '',
  `statut` VARCHAR(6) NOT NULL DEFAULT '0',
  `id_auteur` BIGINT(21) NOT NULL DEFAULT '0',
  `maj` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `destinataires` text NOT NULL,
  PRIMARY KEY (`id_message`),
  KEY `id_auteur` (`id_auteur`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `spip_meta`
--

CREATE TABLE IF NOT EXISTS `spip_meta` (
  `nom` VARCHAR(255) NOT NULL,
  `valeur` text,
  `impt` enum('non','oui') NOT NULL DEFAULT 'oui',
  `maj` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`nom`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `spip_mots`
--

CREATE TABLE IF NOT EXISTS `spip_mots` (
  `id_mot` BIGINT(21) NOT NULL AUTO_INCREMENT,
  `titre` text NOT NULL,
  `descriptif` text NOT NULL,
  `texte` longtext NOT NULL,
  `id_groupe` BIGINT(21) NOT NULL DEFAULT '0',
  `type` text NOT NULL,
  `extra` longtext,
  `maj` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `geocodes` VARCHAR(250) NOT NULL DEFAULT '',
  `longitude` VARCHAR(250) NOT NULL DEFAULT '',
  `focus` VARCHAR(250) NOT NULL DEFAULT '',
  `adresse` VARCHAR(250) NOT NULL DEFAULT '',
  `fnac` VARCHAR(250) NOT NULL DEFAULT '',
  `telephone` VARCHAR(250) NOT NULL DEFAULT '',
  PRIMARY KEY (`id_mot`),
  KEY `id_groupe` (`id_groupe`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=210119 ;

-- --------------------------------------------------------

--
-- Table structure for table `spip_mots_liens`
--

CREATE TABLE IF NOT EXISTS `spip_mots_liens` (
  `id_mot` BIGINT(21) NOT NULL DEFAULT '0',
  `id_objet` BIGINT(21) NOT NULL DEFAULT '0',
  `objet` VARCHAR(25) NOT NULL DEFAULT '',
  PRIMARY KEY (`id_mot`,`id_objet`,`objet`),
  KEY `id_mot` (`id_mot`),
  KEY `id_objet` (`id_objet`),
  KEY `objet` (`objet`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `spip_notations`
--

CREATE TABLE IF NOT EXISTS `spip_notations` (
  `id_notation` BIGINT(21) NOT NULL AUTO_INCREMENT,
  `objet` VARCHAR(21) NOT NULL DEFAULT '',
  `id_objet` BIGINT(21) NOT NULL DEFAULT '0',
  `id_auteur` BIGINT(21) NOT NULL,
  `ip` VARCHAR(255) NOT NULL,
  `note` tinyint(1) NOT NULL,
  `maj` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_notation`),
  KEY `objet` (`objet`),
  KEY `id_objet` (`id_objet`),
  KEY `id_auteur` (`id_auteur`),
  KEY `ip` (`ip`),
  KEY `note` (`note`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=385 ;

-- --------------------------------------------------------

--
-- Table structure for table `spip_notations_objets`
--

CREATE TABLE IF NOT EXISTS `spip_notations_objets` (
  `objet` VARCHAR(21) NOT NULL DEFAULT '',
  `id_objet` BIGINT(21) NOT NULL DEFAULT '0',
  `note` DOUBLE NOT NULL,
  `note_ponderee` DOUBLE NOT NULL,
  `nombre_votes` BIGINT(21) NOT NULL,
  PRIMARY KEY (`objet`,`id_objet`),
  KEY `objet` (`objet`),
  KEY `id_objet` (`id_objet`),
  KEY `note` (`note`),
  KEY `note_ponderee` (`note_ponderee`),
  KEY `nombre_votes` (`nombre_votes`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `spip_paquets`
--

CREATE TABLE IF NOT EXISTS `spip_paquets` (
  `id_paquet` BIGINT(21) NOT NULL AUTO_INCREMENT,
  `id_plugin` BIGINT(21) NOT NULL,
  `prefixe` VARCHAR(30) NOT NULL DEFAULT '',
  `logo` VARCHAR(255) NOT NULL DEFAULT '',
  `version` VARCHAR(24) NOT NULL DEFAULT '',
  `version_base` VARCHAR(24) NOT NULL DEFAULT '',
  `compatibilite_spip` VARCHAR(24) NOT NULL DEFAULT '',
  `branches_spip` VARCHAR(255) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `auteur` text NOT NULL,
  `credit` text NOT NULL,
  `licence` text NOT NULL,
  `copyright` text NOT NULL,
  `lien_doc` text NOT NULL,
  `lien_demo` text NOT NULL,
  `lien_dev` text NOT NULL,
  `etat` VARCHAR(16) NOT NULL DEFAULT '',
  `etatnum` INT(1) NOT NULL DEFAULT '0',
  `dependances` text NOT NULL,
  `date_crea` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_modif` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `id_depot` BIGINT(21) NOT NULL DEFAULT '0',
  `nom_archive` VARCHAR(255) NOT NULL DEFAULT '',
  `nbo_archive` INT(11) NOT NULL DEFAULT '0',
  `maj_archive` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `src_archive` VARCHAR(255) NOT NULL DEFAULT '',
  `traductions` text NOT NULL,
  `actif` VARCHAR(3) NOT NULL DEFAULT 'non',
  `installe` VARCHAR(3) NOT NULL DEFAULT 'non',
  `recent` INT(2) NOT NULL DEFAULT '0',
  `maj_version` VARCHAR(255) NOT NULL DEFAULT '',
  `superieur` VARCHAR(3) NOT NULL DEFAULT 'non',
  `obsolete` VARCHAR(3) NOT NULL DEFAULT 'non',
  `attente` VARCHAR(3) NOT NULL DEFAULT 'non',
  `constante` VARCHAR(30) NOT NULL DEFAULT '',
  `signature` VARCHAR(32) NOT NULL DEFAULT '',
  PRIMARY KEY (`id_paquet`),
  KEY `id_plugin` (`id_plugin`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=14584 ;

-- --------------------------------------------------------

--
-- Table structure for table `spip_petitions`
--

CREATE TABLE IF NOT EXISTS `spip_petitions` (
  `id_petition` BIGINT(21) NOT NULL AUTO_INCREMENT,
  `id_article` BIGINT(21) NOT NULL DEFAULT '0',
  `email_unique` CHAR(3) NOT NULL DEFAULT '',
  `site_obli` CHAR(3) NOT NULL DEFAULT '',
  `site_unique` CHAR(3) NOT NULL DEFAULT '',
  `message` CHAR(3) NOT NULL DEFAULT '',
  `texte` longtext NOT NULL,
  `maj` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `statut` VARCHAR(10) NOT NULL DEFAULT 'publie',
  PRIMARY KEY (`id_petition`),
  UNIQUE KEY `id_article` (`id_article`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--
-- Table structure for table `spip_plugins`
--

CREATE TABLE IF NOT EXISTS `spip_plugins` (
  `id_plugin` BIGINT(21) NOT NULL AUTO_INCREMENT,
  `prefixe` VARCHAR(30) NOT NULL DEFAULT '',
  `nom` text NOT NULL,
  `slogan` text NOT NULL,
  `categorie` VARCHAR(100) NOT NULL DEFAULT '',
  `tags` text NOT NULL,
  `vmax` VARCHAR(24) NOT NULL DEFAULT '',
  `date_crea` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_modif` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `compatibilite_spip` VARCHAR(24) NOT NULL DEFAULT '',
  `branches_spip` VARCHAR(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id_plugin`),
  KEY `prefixe` (`prefixe`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11885 ;

-- --------------------------------------------------------

--
-- Table structure for table `spip_pratiques`
--

CREATE TABLE IF NOT EXISTS `spip_pratiques` (
  `id_pratique` BIGINT(21) NOT NULL AUTO_INCREMENT,
  `id_rubrique` BIGINT(21) NOT NULL DEFAULT '0',
  `id_secteur` BIGINT(21) NOT NULL DEFAULT '0',
  `titre` text NOT NULL,
  `adresse` text,
  `telephone` text,
  `horaires` mediumtext NOT NULL,
  `descriptif` mediumtext NOT NULL,
  `qui` mediumtext NOT NULL,
  `comment` mediumtext NOT NULL,
  `lieu` VARCHAR(144) NOT NULL,
  `conseil` mediumtext NOT NULL,
  `lien` tinytext NOT NULL,
  `url` VARCHAR(255) NOT NULL DEFAULT '',
  `date_publication` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `statut` VARCHAR(20) NOT NULL DEFAULT '0',
  `lang` VARCHAR(10) NOT NULL DEFAULT '',
  `langue_choisie` VARCHAR(3) DEFAULT 'non',
  `id_trad` BIGINT(21) NOT NULL DEFAULT '0',
  `maj` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `case_1` VARCHAR(3) NOT NULL DEFAULT '',
  PRIMARY KEY (`id_pratique`),
  KEY `id_rubrique` (`id_rubrique`),
  KEY `id_secteur` (`id_secteur`),
  KEY `lang` (`lang`),
  KEY `id_trad` (`id_trad`),
  KEY `statut` (`statut`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=50 ;

-- --------------------------------------------------------

--
-- Table structure for table `spip_pratiques_liens`
--

CREATE TABLE IF NOT EXISTS `spip_pratiques_liens` (
  `id_pratique` BIGINT(21) NOT NULL DEFAULT '0',
  `id_objet` BIGINT(21) NOT NULL DEFAULT '0',
  `objet` VARCHAR(25) NOT NULL DEFAULT '',
  `vu` VARCHAR(6) NOT NULL DEFAULT 'non',
  PRIMARY KEY (`id_pratique`,`id_objet`,`objet`),
  KEY `id_pratique` (`id_pratique`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `spip_referers`
--

CREATE TABLE IF NOT EXISTS `spip_referers` (
  `referer_md5` BIGINT(20) UNSIGNED NOT NULL,
  `date` DATE NOT NULL,
  `referer` VARCHAR(255) DEFAULT NULL,
  `visites` INT(10) UNSIGNED NOT NULL,
  `maj` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `visites_veille` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `visites_jour` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`referer_md5`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `spip_referers_articles`
--

CREATE TABLE IF NOT EXISTS `spip_referers_articles` (
  `id_article` INT(10) UNSIGNED NOT NULL,
  `referer_md5` BIGINT(20) UNSIGNED NOT NULL,
  `referer` VARCHAR(255) NOT NULL DEFAULT '',
  `visites` INT(10) UNSIGNED NOT NULL,
  `maj` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_article`,`referer_md5`),
  KEY `referer_md5` (`referer_md5`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `spip_resultats`
--

CREATE TABLE IF NOT EXISTS `spip_resultats` (
  `recherche` CHAR(16) NOT NULL DEFAULT '',
  `id` INT(10) UNSIGNED NOT NULL,
  `points` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `maj` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `table_objet` VARCHAR(30) NOT NULL DEFAULT '',
  `serveur` CHAR(16) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `spip_rubriques`
--

CREATE TABLE IF NOT EXISTS `spip_rubriques` (
  `id_rubrique` BIGINT(21) NOT NULL AUTO_INCREMENT,
  `id_parent` BIGINT(21) NOT NULL DEFAULT '0',
  `titre` text NOT NULL,
  `descriptif` text NOT NULL,
  `texte` longtext NOT NULL,
  `id_secteur` BIGINT(21) NOT NULL DEFAULT '0',
  `maj` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `statut` VARCHAR(10) NOT NULL DEFAULT '0',
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `lang` VARCHAR(10) NOT NULL DEFAULT '',
  `langue_choisie` VARCHAR(3) DEFAULT 'non',
  `extra` longtext,
  `statut_tmp` VARCHAR(10) NOT NULL DEFAULT '0',
  `date_tmp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `agenda` tinyint(1) NOT NULL DEFAULT '0',
  `geocodes` VARCHAR(250) NOT NULL DEFAULT '',
  `recherchehotel` VARCHAR(250) NOT NULL DEFAULT '',
  `format_rubrique` text NOT NULL,
  `telephone_rubrique` text NOT NULL,
  `adresse_rubrique` text NOT NULL,
  `longitude` text NOT NULL,
  `profondeur` SMALLINT(5) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_rubrique`),
  KEY `lang` (`lang`),
  KEY `id_parent` (`id_parent`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=113779 ;

-- --------------------------------------------------------

--
-- Table structure for table `spip_rubriques_liens`
--

CREATE TABLE IF NOT EXISTS `spip_rubriques_liens` (
  `id_parent` BIGINT(21) NOT NULL DEFAULT '0',
  `id_objet` BIGINT(21) NOT NULL DEFAULT '0',
  `objet` VARCHAR(25) NOT NULL DEFAULT '',
  PRIMARY KEY (`id_parent`,`id_objet`,`objet`),
  KEY `id_parent` (`id_parent`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `spip_signatures`
--

CREATE TABLE IF NOT EXISTS `spip_signatures` (
  `id_signature` BIGINT(21) NOT NULL AUTO_INCREMENT,
  `date_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `nom_email` text NOT NULL,
  `ad_email` text NOT NULL,
  `nom_site` text NOT NULL,
  `url_site` text NOT NULL,
  `message` mediumtext NOT NULL,
  `statut` VARCHAR(10) NOT NULL DEFAULT '0',
  `maj` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `id_petition` BIGINT(21) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_signature`),
  KEY `statut` (`statut`),
  KEY `id_petition` (`id_petition`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--
-- Table structure for table `spip_syndic`
--

CREATE TABLE IF NOT EXISTS `spip_syndic` (
  `id_syndic` BIGINT(21) NOT NULL AUTO_INCREMENT,
  `id_rubrique` BIGINT(21) NOT NULL DEFAULT '0',
  `id_secteur` BIGINT(21) NOT NULL DEFAULT '0',
  `nom_site` text NOT NULL,
  `url_site` text NOT NULL,
  `url_syndic` text NOT NULL,
  `descriptif` text NOT NULL,
  `maj` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `syndication` VARCHAR(3) NOT NULL DEFAULT '',
  `statut` VARCHAR(10) NOT NULL DEFAULT '0',
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_syndic` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_index` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `extra` longtext,
  `moderation` VARCHAR(3) DEFAULT 'non',
  `miroir` VARCHAR(3) DEFAULT 'non',
  `oubli` VARCHAR(3) DEFAULT 'non',
  `resume` VARCHAR(3) DEFAULT 'oui',
  PRIMARY KEY (`id_syndic`),
  KEY `id_rubrique` (`id_rubrique`),
  KEY `id_secteur` (`id_secteur`),
  KEY `statut` (`statut`,`date_syndic`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `spip_syndic_articles`
--

CREATE TABLE IF NOT EXISTS `spip_syndic_articles` (
  `id_syndic_article` BIGINT(21) NOT NULL AUTO_INCREMENT,
  `id_syndic` BIGINT(21) NOT NULL DEFAULT '0',
  `titre` text NOT NULL,
  `url` VARCHAR(255) NOT NULL DEFAULT '',
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `lesauteurs` text NOT NULL,
  `maj` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `statut` VARCHAR(10) NOT NULL DEFAULT '0',
  `descriptif` text NOT NULL,
  `lang` VARCHAR(10) NOT NULL DEFAULT '',
  `url_source` tinytext NOT NULL,
  `source` tinytext NOT NULL,
  `tags` text NOT NULL,
  PRIMARY KEY (`id_syndic_article`),
  KEY `id_syndic` (`id_syndic`),
  KEY `statut` (`statut`),
  KEY `url` (`url`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `spip_test`
--

CREATE TABLE IF NOT EXISTS `spip_test` (
  `a` INT(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `spip_types_documents`
--

CREATE TABLE IF NOT EXISTS `spip_types_documents` (
  `extension` VARCHAR(10) NOT NULL DEFAULT '',
  `titre` text NOT NULL,
  `descriptif` text NOT NULL,
  `mime_type` VARCHAR(100) NOT NULL DEFAULT '',
  `inclus` enum('non','image','embed') NOT NULL DEFAULT 'non',
  `upload` enum('oui','non') NOT NULL DEFAULT 'oui',
  `maj` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `media_defaut` VARCHAR(10) NOT NULL DEFAULT 'file',
  PRIMARY KEY (`extension`),
  KEY `inclus` (`inclus`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `spip_urls`
--

CREATE TABLE IF NOT EXISTS `spip_urls` (
  `url` VARCHAR(255) NOT NULL,
  `type` VARCHAR(25) NOT NULL DEFAULT 'article',
  `id_objet` BIGINT(21) NOT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `id_parent` BIGINT(21) NOT NULL DEFAULT '0',
  `segments` SMALLINT(3) NOT NULL DEFAULT '1',
  `perma` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_parent`,`url`),
  KEY `type` (`type`,`id_objet`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `spip_versions`
--

CREATE TABLE IF NOT EXISTS `spip_versions` (
  `id_objet` BIGINT(21) NOT NULL DEFAULT '0',
  `objet` VARCHAR(25) NOT NULL DEFAULT '',
  `id_version` BIGINT(21) NOT NULL DEFAULT '0',
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `id_auteur` VARCHAR(23) NOT NULL DEFAULT '',
  `titre_version` text NOT NULL,
  `permanent` CHAR(3) NOT NULL DEFAULT '',
  `champs` text NOT NULL,
  PRIMARY KEY (`id_version`,`id_objet`,`objet`),
  KEY `id_version` (`id_version`),
  KEY `id_objet` (`id_objet`),
  KEY `objet` (`objet`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `spip_versions_fragments`
--

CREATE TABLE IF NOT EXISTS `spip_versions_fragments` (
  `id_fragment` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `version_min` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `version_max` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `id_objet` BIGINT(21) NOT NULL DEFAULT '0',
  `objet` VARCHAR(25) NOT NULL DEFAULT '',
  `compress` tinyint(4) NOT NULL,
  `fragment` longblob,
  PRIMARY KEY (`id_objet`,`objet`,`id_fragment`,`version_min`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `spip_visites`
--

CREATE TABLE IF NOT EXISTS `spip_visites` (
  `date` DATE NOT NULL,
  `visites` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `maj` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `spip_visites_articles`
--

CREATE TABLE IF NOT EXISTS `spip_visites_articles` (
  `date` DATE NOT NULL,
  `id_article` INT(10) UNSIGNED NOT NULL,
  `visites` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `maj` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`date`,`id_article`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `TABLE 48`
--

CREATE TABLE IF NOT EXISTS `TABLE 48` (
  `COL 1` INT(6) DEFAULT NULL,
  `COL 2` VARCHAR(72) DEFAULT NULL,
  `COL 3` VARCHAR(493) DEFAULT NULL,
  `COL 4` VARCHAR(382) DEFAULT NULL,
  `COL 5` INT(2) DEFAULT NULL,
  `COL 6` VARCHAR(30) DEFAULT NULL,
  `COL 7` VARCHAR(10) DEFAULT NULL,
  `COL 8` VARCHAR(19) DEFAULT NULL,
  `COL 9` VARCHAR(10) DEFAULT NULL,
  `COL 10` VARCHAR(10) DEFAULT NULL,
  `COL 11` VARCHAR(2) DEFAULT NULL,
  `COL 12` VARCHAR(40) DEFAULT NULL,
  `COL 13` VARCHAR(10) DEFAULT NULL,
  `COL 14` VARCHAR(21) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;