-- phpMyAdmin SQL Dump
-- version 2.6.2-Debian-3sarge3
-- http://www.phpmyadmin.net
-- 
-- Serveur: localhost
-- Généré le : Mardi 27 Novembre 2007 à 18:27
-- Version du serveur: 4.0.24
-- Version de PHP: 4.3.10-21
-- 
-- Base de données: `spip-africagrenouille`
-- 

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

-- 
-- Structure de la table `spip_articles`
-- 

CREATE TABLE `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` longblob 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(14) NOT NULL,
  `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 '',
  `auteur_modif` bigint(21) NOT NULL default '0',
  `date_modif` datetime NOT NULL default '0000-00-00 00:00:00',
  `lang` varchar(10) NOT NULL default '',
  `langue_choisie` char(3) default 'non',
  `id_trad` bigint(21) NOT NULL default '0',
  `extra` longblob,
  `idx` enum('','1','non','oui','idx') NOT NULL default '',
  `id_version` int(10) unsigned NOT NULL default '0',
  `nom_site` tinytext NOT NULL,
  `url_site` varchar(255) NOT NULL default '',
  `url_propre` varchar(255) 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`),
  KEY `url_site` (`url_site`),
  KEY `date_modif` (`date_modif`),
  KEY `idx` (`idx`),
  KEY `url_propre` (`url_propre`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_auteurs`
-- 

CREATE TABLE `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) binary NOT NULL default '',
  `pass` tinytext NOT NULL,
  `low_sec` tinytext NOT NULL,
  `statut` varchar(255) NOT NULL default '',
  `maj` timestamp(14) NOT NULL,
  `pgp` blob NOT NULL,
  `htpass` tinyblob NOT NULL,
  `en_ligne` datetime NOT NULL default '0000-00-00 00:00:00',
  `imessage` char(3) NOT NULL default '',
  `messagerie` char(3) NOT NULL default '',
  `alea_actuel` tinytext NOT NULL,
  `alea_futur` tinytext NOT NULL,
  `prefs` tinytext NOT NULL,
  `cookie_oubli` tinytext NOT NULL,
  `source` varchar(10) NOT NULL default 'spip',
  `lang` varchar(10) NOT NULL default '',
  `idx` enum('','1','non','oui','idx') NOT NULL default '',
  `extra` longblob,
  `url_propre` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id_auteur`),
  KEY `login` (`login`),
  KEY `statut` (`statut`),
  KEY `lang` (`lang`),
  KEY `idx` (`idx`),
  KEY `en_ligne` (`en_ligne`),
  KEY `url_propre` (`url_propre`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_auteurs_articles`
-- 

CREATE TABLE `spip_auteurs_articles` (
  `id_auteur` bigint(21) NOT NULL default '0',
  `id_article` bigint(21) NOT NULL default '0',
  KEY `id_auteur` (`id_auteur`),
  KEY `id_article` (`id_article`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_auteurs_messages`
-- 

CREATE TABLE `spip_auteurs_messages` (
  `id_auteur` bigint(21) NOT NULL default '0',
  `id_message` bigint(21) NOT NULL default '0',
  `vu` char(3) NOT NULL default '',
  KEY `id_auteur` (`id_auteur`),
  KEY `id_message` (`id_message`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_auteurs_rubriques`
-- 

CREATE TABLE `spip_auteurs_rubriques` (
  `id_auteur` bigint(21) NOT NULL default '0',
  `id_rubrique` bigint(21) NOT NULL default '0',
  KEY `id_auteur` (`id_auteur`),
  KEY `id_rubrique` (`id_rubrique`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_breves`
-- 

CREATE TABLE `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` longblob NOT NULL,
  `lien_titre` text NOT NULL,
  `lien_url` text NOT NULL,
  `statut` varchar(6) NOT NULL default '',
  `id_rubrique` bigint(21) NOT NULL default '0',
  `lang` varchar(10) NOT NULL default '',
  `langue_choisie` char(3) default 'non',
  `maj` timestamp(14) NOT NULL,
  `idx` enum('','1','non','oui','idx') NOT NULL default '',
  `extra` longblob,
  `url_propre` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id_breve`),
  KEY `idx` (`idx`),
  KEY `id_rubrique` (`id_rubrique`),
  KEY `url_propre` (`url_propre`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_caches`
-- 

CREATE TABLE `spip_caches` (
  `fichier` char(64) NOT NULL default '',
  `id` char(64) NOT NULL default '',
  `type` char(1) NOT NULL default 'i',
  `taille` int(11) NOT NULL default '0',
  PRIMARY KEY  (`fichier`,`id`),
  KEY `fichier` (`fichier`),
  KEY `id` (`id`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_documents`
-- 

CREATE TABLE `spip_documents` (
  `id_document` bigint(21) NOT NULL auto_increment,
  `id_vignette` bigint(21) NOT NULL default '0',
  `id_type` bigint(21) NOT NULL default '0',
  `titre` text NOT NULL,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `descriptif` text NOT NULL,
  `fichier` varchar(255) NOT NULL default '',
  `taille` int(11) NOT NULL default '0',
  `largeur` int(11) NOT NULL default '0',
  `hauteur` int(11) NOT NULL default '0',
  `mode` enum('vignette','document') NOT NULL default 'vignette',
  `inclus` char(3) default 'non',
  `maj` timestamp(14) NOT NULL,
  `idx` enum('','1','non','oui','idx') NOT NULL default '',
  `distant` char(3) default 'non',
  PRIMARY KEY  (`id_document`),
  KEY `id_vignette` (`id_vignette`),
  KEY `mode` (`mode`),
  KEY `id_type` (`id_type`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_documents_articles`
-- 

CREATE TABLE `spip_documents_articles` (
  `id_document` bigint(21) NOT NULL default '0',
  `id_article` bigint(21) NOT NULL default '0',
  KEY `id_document` (`id_document`),
  KEY `id_article` (`id_article`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_documents_breves`
-- 

CREATE TABLE `spip_documents_breves` (
  `id_document` bigint(21) NOT NULL default '0',
  `id_breve` bigint(21) NOT NULL default '0',
  KEY `id_document` (`id_document`),
  KEY `id_breve` (`id_breve`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_documents_rubriques`
-- 

CREATE TABLE `spip_documents_rubriques` (
  `id_document` bigint(21) NOT NULL default '0',
  `id_rubrique` bigint(21) NOT NULL default '0',
  KEY `id_document` (`id_document`),
  KEY `id_rubrique` (`id_rubrique`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_forum`
-- 

CREATE TABLE `spip_forum` (
  `id_forum` bigint(21) NOT NULL auto_increment,
  `id_parent` bigint(21) NOT NULL default '0',
  `id_thread` bigint(21) NOT NULL default '0',
  `id_rubrique` bigint(21) NOT NULL default '0',
  `id_article` bigint(21) NOT NULL default '0',
  `id_breve` bigint(21) NOT NULL default '0',
  `date_heure` 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 '',
  `idx` enum('','1','non','oui','idx') NOT NULL default '',
  `ip` varchar(16) default NULL,
  `maj` timestamp(14) NOT NULL,
  `id_auteur` bigint(20) NOT NULL default '0',
  `id_message` bigint(21) NOT NULL default '0',
  `id_syndic` bigint(21) NOT NULL default '0',
  PRIMARY KEY  (`id_forum`),
  KEY `id_parent` (`id_parent`),
  KEY `id_rubrique` (`id_rubrique`),
  KEY `id_article` (`id_article`),
  KEY `id_breve` (`id_breve`),
  KEY `id_message` (`id_message`),
  KEY `id_syndic` (`id_syndic`),
  KEY `idx` (`idx`),
  KEY `statut` (`statut`,`date_heure`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_groupes_mots`
-- 

CREATE TABLE `spip_groupes_mots` (
  `id_groupe` bigint(21) NOT NULL auto_increment,
  `titre` text NOT NULL,
  `unseul` char(3) NOT NULL default '',
  `obligatoire` char(3) NOT NULL default '',
  `articles` char(3) NOT NULL default '',
  `breves` char(3) NOT NULL default '',
  `rubriques` char(3) NOT NULL default '',
  `syndic` char(3) NOT NULL default '',
  `0minirezo` char(3) NOT NULL default '',
  `1comite` char(3) NOT NULL default '',
  `6forum` char(3) NOT NULL default '',
  `maj` timestamp(14) NOT NULL,
  PRIMARY KEY  (`id_groupe`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_index_articles`
-- 

CREATE TABLE `spip_index_articles` (
  `hash` bigint(20) unsigned NOT NULL default '0',
  `points` int(10) unsigned NOT NULL default '0',
  `id_article` int(10) unsigned NOT NULL default '0',
  KEY `hash` (`hash`),
  KEY `id_article` (`id_article`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_index_auteurs`
-- 

CREATE TABLE `spip_index_auteurs` (
  `hash` bigint(20) unsigned NOT NULL default '0',
  `points` int(10) unsigned NOT NULL default '0',
  `id_auteur` int(10) unsigned NOT NULL default '0',
  KEY `hash` (`hash`),
  KEY `id_auteur` (`id_auteur`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_index_breves`
-- 

CREATE TABLE `spip_index_breves` (
  `hash` bigint(20) unsigned NOT NULL default '0',
  `points` int(10) unsigned NOT NULL default '0',
  `id_breve` int(10) unsigned NOT NULL default '0',
  KEY `hash` (`hash`),
  KEY `id_breve` (`id_breve`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_index_dico`
-- 

CREATE TABLE `spip_index_dico` (
  `hash` bigint(20) unsigned NOT NULL default '0',
  `dico` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`dico`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_index_forum`
-- 

CREATE TABLE `spip_index_forum` (
  `hash` bigint(20) unsigned NOT NULL default '0',
  `points` int(10) unsigned NOT NULL default '0',
  `id_forum` int(10) unsigned NOT NULL default '0',
  KEY `hash` (`hash`),
  KEY `id_forum` (`id_forum`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_index_mots`
-- 

CREATE TABLE `spip_index_mots` (
  `hash` bigint(20) unsigned NOT NULL default '0',
  `points` int(10) unsigned NOT NULL default '0',
  `id_mot` int(10) unsigned NOT NULL default '0',
  KEY `hash` (`hash`),
  KEY `id_mot` (`id_mot`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_index_rubriques`
-- 

CREATE TABLE `spip_index_rubriques` (
  `hash` bigint(20) unsigned NOT NULL default '0',
  `points` int(10) unsigned NOT NULL default '0',
  `id_rubrique` int(10) unsigned NOT NULL default '0',
  KEY `hash` (`hash`),
  KEY `id_rubrique` (`id_rubrique`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_index_signatures`
-- 

CREATE TABLE `spip_index_signatures` (
  `hash` bigint(20) unsigned NOT NULL default '0',
  `points` int(10) unsigned NOT NULL default '0',
  `id_signature` int(10) unsigned NOT NULL default '0',
  KEY `hash` (`hash`),
  KEY `id_signature` (`id_signature`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_index_syndic`
-- 

CREATE TABLE `spip_index_syndic` (
  `hash` bigint(20) unsigned NOT NULL default '0',
  `points` int(10) unsigned NOT NULL default '0',
  `id_syndic` int(10) unsigned NOT NULL default '0',
  KEY `hash` (`hash`),
  KEY `id_syndic` (`id_syndic`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_messages`
-- 

CREATE TABLE `spip_messages` (
  `id_message` bigint(21) NOT NULL auto_increment,
  `titre` text NOT NULL,
  `texte` longblob 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` char(3) NOT NULL default '',
  `statut` varchar(6) NOT NULL default '',
  `id_auteur` bigint(21) NOT NULL default '0',
  `maj` timestamp(14) NOT NULL,
  PRIMARY KEY  (`id_message`),
  KEY `id_auteur` (`id_auteur`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_meta`
-- 

CREATE TABLE `spip_meta` (
  `nom` varchar(255) NOT NULL default '',
  `valeur` varchar(255) default '',
  `maj` timestamp(14) NOT NULL,
  PRIMARY KEY  (`nom`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_mots`
-- 

CREATE TABLE `spip_mots` (
  `id_mot` bigint(21) NOT NULL auto_increment,
  `type` varchar(100) NOT NULL default '',
  `titre` text NOT NULL,
  `descriptif` text NOT NULL,
  `texte` longblob NOT NULL,
  `id_groupe` bigint(21) NOT NULL default '0',
  `extra` longblob,
  `idx` enum('','1','non','oui','idx') NOT NULL default '',
  `url_propre` varchar(255) NOT NULL default '',
  `maj` timestamp(14) NOT NULL,
  PRIMARY KEY  (`id_mot`),
  KEY `idx` (`idx`),
  KEY `type` (`type`),
  KEY `url_propre` (`url_propre`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_mots_articles`
-- 

CREATE TABLE `spip_mots_articles` (
  `id_mot` bigint(21) NOT NULL default '0',
  `id_article` bigint(21) NOT NULL default '0',
  KEY `id_mot` (`id_mot`),
  KEY `id_article` (`id_article`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_mots_breves`
-- 

CREATE TABLE `spip_mots_breves` (
  `id_mot` bigint(21) NOT NULL default '0',
  `id_breve` bigint(21) NOT NULL default '0',
  KEY `id_mot` (`id_mot`),
  KEY `id_breve` (`id_breve`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_mots_documents`
-- 

CREATE TABLE `spip_mots_documents` (
  `id_mot` bigint(21) NOT NULL default '0',
  `id_document` bigint(21) NOT NULL default '0',
  KEY `id_mot` (`id_mot`),
  KEY `id_document` (`id_document`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_mots_forum`
-- 

CREATE TABLE `spip_mots_forum` (
  `id_mot` bigint(21) NOT NULL default '0',
  `id_forum` bigint(21) NOT NULL default '0',
  KEY `id_mot` (`id_mot`),
  KEY `id_forum` (`id_forum`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_mots_rubriques`
-- 

CREATE TABLE `spip_mots_rubriques` (
  `id_mot` bigint(21) NOT NULL default '0',
  `id_rubrique` bigint(21) NOT NULL default '0',
  KEY `id_mot` (`id_mot`),
  KEY `id_rubrique` (`id_rubrique`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_mots_syndic`
-- 

CREATE TABLE `spip_mots_syndic` (
  `id_mot` bigint(21) NOT NULL default '0',
  `id_syndic` bigint(21) NOT NULL default '0',
  KEY `id_mot` (`id_mot`),
  KEY `id_syndic` (`id_syndic`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_ortho_cache`
-- 

CREATE TABLE `spip_ortho_cache` (
  `lang` varchar(10) NOT NULL default '',
  `mot` varchar(255) binary NOT NULL default '',
  `ok` tinyint(4) NOT NULL default '0',
  `suggest` blob NOT NULL,
  `maj` timestamp(14) NOT NULL,
  PRIMARY KEY  (`lang`,`mot`),
  KEY `maj` (`maj`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_ortho_dico`
-- 

CREATE TABLE `spip_ortho_dico` (
  `lang` varchar(10) NOT NULL default '',
  `mot` varchar(255) binary NOT NULL default '',
  `id_auteur` bigint(20) unsigned NOT NULL default '0',
  `maj` timestamp(14) NOT NULL,
  PRIMARY KEY  (`lang`,`mot`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_petitions`
-- 

CREATE TABLE `spip_petitions` (
  `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` longblob NOT NULL,
  `maj` timestamp(14) NOT NULL,
  PRIMARY KEY  (`id_article`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_referers`
-- 

CREATE TABLE `spip_referers` (
  `referer_md5` bigint(20) unsigned NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  `referer` varchar(255) NOT NULL default '',
  `visites` int(10) unsigned NOT NULL default '0',
  `visites_jour` int(10) unsigned NOT NULL default '0',
  `visites_veille` int(10) unsigned NOT NULL default '0',
  `maj` timestamp(14) NOT NULL,
  PRIMARY KEY  (`referer_md5`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_referers_articles`
-- 

CREATE TABLE `spip_referers_articles` (
  `id_article` int(10) unsigned NOT NULL default '0',
  `referer_md5` bigint(20) unsigned NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  `referer` varchar(255) NOT NULL default '',
  `visites` int(10) unsigned NOT NULL default '0',
  `maj` timestamp(14) NOT NULL,
  PRIMARY KEY  (`id_article`,`referer_md5`),
  KEY `referer_md5` (`referer_md5`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_referers_temp`
-- 

CREATE TABLE `spip_referers_temp` (
  `ip` int(10) unsigned NOT NULL default '0',
  `referer` varchar(255) NOT NULL default '',
  `referer_md5` bigint(20) unsigned NOT NULL default '0',
  `type` enum('article','rubrique','breve','autre') NOT NULL default 'article',
  `id_objet` int(10) unsigned NOT NULL default '0',
  `maj` timestamp(14) NOT NULL,
  PRIMARY KEY  (`type`,`id_objet`,`referer_md5`,`ip`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_rubriques`
-- 

CREATE TABLE `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` longblob NOT NULL,
  `id_secteur` bigint(21) NOT NULL default '0',
  `maj` timestamp(14) NOT NULL,
  `export` varchar(10) default 'oui',
  `id_import` bigint(20) default '0',
  `statut` varchar(10) NOT NULL default '',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `lang` varchar(10) NOT NULL default '',
  `langue_choisie` char(3) default 'non',
  `idx` enum('','1','non','oui','idx') NOT NULL default '',
  `extra` longblob,
  `url_propre` varchar(255) NOT NULL default '',
  `statut_tmp` varchar(10) NOT NULL default '',
  `date_tmp` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id_rubrique`),
  KEY `lang` (`lang`),
  KEY `idx` (`idx`),
  KEY `id_parent` (`id_parent`),
  KEY `url_propre` (`url_propre`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_signatures`
-- 

CREATE TABLE `spip_signatures` (
  `id_signature` bigint(21) NOT NULL auto_increment,
  `id_article` bigint(21) NOT NULL default '0',
  `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 '',
  `idx` enum('','1','non','oui','idx') NOT NULL default '',
  `maj` timestamp(14) NOT NULL,
  PRIMARY KEY  (`id_signature`),
  KEY `id_article` (`id_article`),
  KEY `idx` (`idx`),
  KEY `statut` (`statut`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_syndic`
-- 

CREATE TABLE `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` blob NOT NULL,
  `url_site` blob NOT NULL,
  `url_syndic` blob NOT NULL,
  `descriptif` blob NOT NULL,
  `idx` enum('','1','non','oui','idx') NOT NULL default '',
  `maj` timestamp(14) NOT NULL,
  `syndication` char(3) NOT NULL default '',
  `statut` varchar(10) NOT NULL default '',
  `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',
  `moderation` char(3) NOT NULL default '',
  `extra` longblob,
  `url_propre` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id_syndic`),
  KEY `id_rubrique` (`id_rubrique`),
  KEY `id_secteur` (`id_secteur`),
  KEY `idx` (`idx`),
  KEY `statut` (`statut`,`date_syndic`),
  KEY `url_propre` (`url_propre`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_syndic_articles`
-- 

CREATE TABLE `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(14) NOT NULL,
  `statut` varchar(10) NOT NULL default '',
  `descriptif` blob NOT NULL,
  PRIMARY KEY  (`id_syndic_article`),
  KEY `id_syndic` (`id_syndic`),
  KEY `statut` (`statut`),
  KEY `url` (`url`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_test`
-- 

CREATE TABLE `spip_test` (
  `a` int(11) default NULL
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_types_documents`
-- 

CREATE TABLE `spip_types_documents` (
  `id_type` bigint(21) NOT NULL auto_increment,
  `titre` text NOT NULL,
  `descriptif` text NOT NULL,
  `extension` varchar(10) NOT NULL default '',
  `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(14) NOT NULL,
  PRIMARY KEY  (`id_type`),
  UNIQUE KEY `extension` (`extension`),
  KEY `inclus` (`inclus`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_versions`
-- 

CREATE TABLE `spip_versions` (
  `id_article` bigint(21) NOT NULL default '0',
  `id_version` int(10) unsigned NOT NULL default '0',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `id_auteur` bigint(21) NOT NULL default '0',
  `titre_version` text NOT NULL,
  `permanent` char(3) NOT NULL default '',
  `champs` text NOT NULL,
  PRIMARY KEY  (`id_article`,`id_version`),
  KEY `date` (`id_article`,`date`),
  KEY `id_auteur` (`id_auteur`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_versions_fragments`
-- 

CREATE TABLE `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_article` bigint(21) NOT NULL default '0',
  `compress` tinyint(4) NOT NULL default '0',
  `fragment` longblob NOT NULL,
  PRIMARY KEY  (`id_article`,`id_fragment`,`version_min`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_visites`
-- 

CREATE TABLE `spip_visites` (
  `date` date NOT NULL default '0000-00-00',
  `visites` int(10) unsigned NOT NULL default '0',
  `maj` timestamp(14) NOT NULL,
  PRIMARY KEY  (`date`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_visites_articles`
-- 

CREATE TABLE `spip_visites_articles` (
  `date` date NOT NULL default '0000-00-00',
  `id_article` int(10) unsigned NOT NULL default '0',
  `visites` int(10) unsigned NOT NULL default '0',
  `maj` timestamp(14) NOT NULL,
  PRIMARY KEY  (`date`,`id_article`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `spip_visites_temp`
-- 

CREATE TABLE `spip_visites_temp` (
  `ip` int(10) unsigned NOT NULL default '0',
  `type` enum('article','rubrique','breve','autre') NOT NULL default 'article',
  `id_objet` int(10) unsigned NOT NULL default '0',
  `maj` timestamp(14) NOT NULL,
  PRIMARY KEY  (`type`,`id_objet`,`ip`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `wikini_acls`
-- 

CREATE TABLE `wikini_acls` (
  `page_tag` varchar(50) NOT NULL default '',
  `privilege` varchar(20) NOT NULL default '',
  `list` text NOT NULL,
  PRIMARY KEY  (`page_tag`,`privilege`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `wikini_links`
-- 

CREATE TABLE `wikini_links` (
  `from_tag` char(50) NOT NULL default '',
  `to_tag` char(50) NOT NULL default '',
  UNIQUE KEY `from_tag` (`from_tag`,`to_tag`),
  KEY `idx_from` (`from_tag`),
  KEY `idx_to` (`to_tag`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `wikini_pages`
-- 

CREATE TABLE `wikini_pages` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `tag` varchar(50) NOT NULL default '',
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `body` text NOT NULL,
  `body_r` text NOT NULL,
  `owner` varchar(50) NOT NULL default '',
  `user` varchar(50) NOT NULL default '',
  `latest` enum('Y','N') NOT NULL default 'N',
  `handler` varchar(30) NOT NULL default 'page',
  `comment_on` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `idx_tag` (`tag`),
  KEY `idx_time` (`time`),
  KEY `idx_latest` (`latest`),
  KEY `idx_comment_on` (`comment_on`),
  FULLTEXT KEY `tag` (`tag`,`body`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `wikini_referrers`
-- 

CREATE TABLE `wikini_referrers` (
  `page_tag` char(50) NOT NULL default '',
  `referrer` char(150) NOT NULL default '',
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  KEY `idx_page_tag` (`page_tag`),
  KEY `idx_time` (`time`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `wikini_users`
-- 

CREATE TABLE `wikini_users` (
  `name` varchar(80) NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `motto` text NOT NULL,
  `revisioncount` int(10) unsigned NOT NULL default '20',
  `changescount` int(10) unsigned NOT NULL default '50',
  `doubleclickedit` enum('Y','N') NOT NULL default 'Y',
  `signuptime` datetime NOT NULL default '0000-00-00 00:00:00',
  `show_comments` enum('Y','N') NOT NULL default 'N',
  PRIMARY KEY  (`name`),
  KEY `idx_name` (`name`),
  KEY `idx_signuptime` (`signuptime`)
) TYPE=MyISAM;