--- /dev/null
+<?php
+
+/***************************************************************************\
+ * SPIP, Systeme de publication pour l'internet *
+ * *
+ * Copyright (c) 2001-2011 *
+ * Arnaud Martin, Antoine Pitrou, Philippe Riviere, Emmanuel Saint-James *
+ * *
+ * Ce programme est un logiciel libre distribue sous licence GNU/GPL. *
+ * Pour plus de details voir le fichier COPYING.txt ou l'aide en ligne. *
+\***************************************************************************/
+
+
+if (!defined('_ECRIRE_INC_VERSION')) return;
+
+$spip_petitions = array(
+ "id_article" => "bigint(21) DEFAULT '0' NOT NULL",
+ "email_unique" => "CHAR (3) DEFAULT '' NOT NULL",
+ "site_obli" => "CHAR (3) DEFAULT '' NOT NULL",
+ "site_unique" => "CHAR (3) DEFAULT '' NOT NULL",
+ "message" => "CHAR (3) DEFAULT '' NOT NULL",
+ "texte" => "LONGTEXT DEFAULT '' NOT NULL",
+ "maj" => "TIMESTAMP");
+
+$spip_petitions_key = array(
+ "PRIMARY KEY" => "id_article");
+
+$spip_visites = array(
+ "date" => "DATE NOT NULL",
+ "visites" => "int UNSIGNED DEFAULT '0' NOT NULL",
+ "maj" => "TIMESTAMP");
+
+$spip_visites_key = array(
+ "PRIMARY KEY" => "date");
+
+$spip_visites_articles = array(
+ "date" => "DATE NOT NULL",
+ "id_article" => "int UNSIGNED NOT NULL",
+ "visites" => "int UNSIGNED DEFAULT '0' NOT NULL",
+ "maj" => "TIMESTAMP");
+
+$spip_visites_articles_key = array(
+ "PRIMARY KEY" => "date, id_article");
+
+$spip_referers = array(
+ "referer_md5" => "bigint UNSIGNED NOT NULL",
+ "date" => "DATE NOT NULL",
+ "referer" => "VARCHAR (255)",
+ "visites" => "int UNSIGNED NOT NULL",
+ "visites_jour" => "int UNSIGNED NOT NULL",
+ "visites_veille"=> "int UNSIGNED NOT NULL",
+ "maj" => "TIMESTAMP");
+
+$spip_referers_key = array(
+ "PRIMARY KEY" => "referer_md5");
+
+$spip_referers_articles = array(
+ "id_article" => "int UNSIGNED NOT NULL",
+ "referer_md5" => "bigint UNSIGNED NOT NULL",
+ "date" => "DATE NOT NULL",
+ "referer" => "VARCHAR (255) DEFAULT '' NOT NULL",
+ "visites" => "int UNSIGNED NOT NULL",
+ "maj" => "TIMESTAMP");
+
+$spip_referers_articles_key = array(
+ "PRIMARY KEY" => "id_article, referer_md5",
+ "KEY referer_md5" => "referer_md5");
+
+$spip_auteurs_articles = array(
+ "id_auteur" => "bigint(21) DEFAULT '0' NOT NULL",
+ "id_article" => "bigint(21) DEFAULT '0' NOT NULL");
+
+$spip_auteurs_articles_key = array(
+ "PRIMARY KEY" => "id_auteur, id_article",
+ "KEY id_article" => "id_article");
+
+$spip_auteurs_rubriques = array(
+ "id_auteur" => "bigint(21) DEFAULT '0' NOT NULL",
+ "id_rubrique" => "bigint(21) DEFAULT '0' NOT NULL");
+
+$spip_auteurs_rubriques_key = array(
+ "PRIMARY KEY" => "id_auteur, id_rubrique",
+ "KEY id_rubrique" => "id_rubrique");
+
+$spip_auteurs_messages = array(
+ "id_auteur" => "bigint(21) DEFAULT '0' NOT NULL",
+ "id_message" => "bigint(21) DEFAULT '0' NOT NULL",
+ "vu" => "CHAR (3)");
+
+$spip_auteurs_messages_key = array(
+ "PRIMARY KEY" => "id_auteur, id_message",
+ "KEY id_message" => "id_message");
+
+
+$spip_documents_articles = array(
+ "id_document" => "bigint(21) DEFAULT '0' NOT NULL",
+ "id_article" => "bigint(21) DEFAULT '0' NOT NULL",
+ "vu" => "ENUM('non', 'oui') DEFAULT 'non' NOT NULL");
+
+$spip_documents_articles_key = array(
+ "PRIMARY KEY" => "id_article, id_document",
+ "KEY id_document" => "id_document");
+
+$spip_documents_rubriques = array(
+ "id_document" => "bigint(21) DEFAULT '0' NOT NULL",
+ "id_rubrique" => "bigint(21) DEFAULT '0' NOT NULL",
+ "vu" => "ENUM('non', 'oui') DEFAULT 'non' NOT NULL");
+
+$spip_documents_rubriques_key = array(
+ "PRIMARY KEY" => "id_rubrique, id_document",
+ "KEY id_document" => "id_document");
+
+$spip_documents_breves = array(
+ "id_document" => "bigint(21) DEFAULT '0' NOT NULL",
+ "id_breve" => "bigint(21) DEFAULT '0' NOT NULL",
+ "vu" => "ENUM('non', 'oui') DEFAULT 'non' NOT NULL");
+
+$spip_documents_breves_key = array(
+ "PRIMARY KEY" => "id_breve, id_document",
+ "KEY id_document" => "id_document");
+
+$spip_mots_articles = array(
+ "id_mot" => "bigint(21) DEFAULT '0' NOT NULL",
+ "id_article" => "bigint(21) DEFAULT '0' NOT NULL");
+
+$spip_mots_articles_key = array(
+ "PRIMARY KEY" => "id_article, id_mot",
+ "KEY id_mot" => "id_mot");
+
+$spip_mots_breves = array(
+ "id_mot" => "bigint(21) DEFAULT '0' NOT NULL",
+ "id_breve" => "bigint(21) DEFAULT '0' NOT NULL");
+
+$spip_mots_breves_key = array(
+ "PRIMARY KEY" => "id_breve, id_mot",
+ "KEY id_mot" => "id_mot");
+
+$spip_mots_rubriques = array(
+ "id_mot" => "bigint(21) DEFAULT '0' NOT NULL",
+ "id_rubrique" => "bigint(21) DEFAULT '0' NOT NULL");
+
+$spip_mots_rubriques_key = array(
+ "PRIMARY KEY" => "id_rubrique, id_mot",
+ "KEY id_mot" => "id_mot");
+
+$spip_mots_syndic = array(
+ "id_mot" => "bigint(21) DEFAULT '0' NOT NULL",
+ "id_syndic" => "bigint(21) DEFAULT '0' NOT NULL");
+
+$spip_mots_syndic_key = array(
+ "PRIMARY KEY" => "id_syndic, id_mot",
+ "KEY id_mot" => "id_mot");
+
+$spip_mots_forum = array(
+ "id_mot" => "bigint(21) DEFAULT '0' NOT NULL",
+ "id_forum" => "bigint(21) DEFAULT '0' NOT NULL");
+
+$spip_mots_forum_key = array(
+ "PRIMARY KEY" => "id_forum, id_mot",
+ "KEY id_mot" => "id_mot");
+
+$spip_mots_documents = array(
+ "id_mot" => "bigint(21) DEFAULT '0' NOT NULL",
+ "id_document" => "bigint(21) DEFAULT '0' NOT NULL");
+
+$spip_mots_documents_key = array(
+ "PRIMARY KEY" => "id_document, id_mot",
+ "KEY id_mot" => "id_mot");
+
+$spip_meta = array(
+ "nom" => "VARCHAR (255) NOT NULL",
+ "valeur" => "text DEFAULT ''",
+ "impt" => "ENUM('non', 'oui') DEFAULT 'oui' NOT NULL",
+ "maj" => "TIMESTAMP");
+
+$spip_meta_key = array(
+ "PRIMARY KEY" => "nom");
+
+$spip_versions = array (
+ "id_article" => "bigint(21) NOT NULL",
+ "id_version" => "int unsigned DEFAULT '0' NOT NULL",
+ "date" => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
+ "id_auteur" => "VARCHAR(23) DEFAULT '' NOT NULL", # stocke aussi IP(v6)
+ "titre_version" => "text DEFAULT '' NOT NULL",
+ "permanent" => "char(3)",
+ "champs" => "text");
+
+$spip_versions_key = array (
+ "PRIMARY KEY" => "id_article, id_version",
+ "KEY date" => "id_article, date",
+ "KEY id_auteur" => "id_auteur");
+
+$spip_versions_fragments = array(
+ "id_fragment" => "int unsigned DEFAULT '0' NOT NULL",
+ "version_min" => "int unsigned DEFAULT '0' NOT NULL",
+ "version_max" => "int unsigned DEFAULT '0' NOT NULL",
+ "id_article" => "bigint(21) NOT NULL",
+ "compress" => "tinyint NOT NULL",
+ "fragment" => "longblob" # ici c'est VRAIMENT un blob (on y stocke du gzip)
+ );
+
+$spip_versions_fragments_key = array(
+ "PRIMARY KEY" => "id_article, id_fragment, version_min");
+
+
+
+
+global $tables_auxiliaires;
+
+$tables_auxiliaires['spip_petitions'] = array(
+ 'field' => &$spip_petitions,
+ 'key' => &$spip_petitions_key
+);
+$tables_auxiliaires['spip_visites'] = array(
+ 'field' => &$spip_visites,
+ 'key' => &$spip_visites_key);
+$tables_auxiliaires['spip_visites_articles'] = array(
+ 'field' => &$spip_visites_articles,
+ 'key' => &$spip_visites_articles_key);
+$tables_auxiliaires['spip_referers'] = array(
+ 'field' => &$spip_referers,
+ 'key' => &$spip_referers_key);
+$tables_auxiliaires['spip_referers_articles'] = array(
+ 'field' => &$spip_referers_articles,
+ 'key' => &$spip_referers_articles_key);
+$tables_auxiliaires['spip_auteurs_articles'] = array(
+ 'field' => &$spip_auteurs_articles,
+ 'key' => &$spip_auteurs_articles_key);
+$tables_auxiliaires['spip_auteurs_rubriques'] = array(
+ 'field' => &$spip_auteurs_rubriques,
+ 'key' => &$spip_auteurs_rubriques_key);
+$tables_auxiliaires['spip_auteurs_messages'] = array(
+ 'field' => &$spip_auteurs_messages,
+ 'key' => &$spip_auteurs_messages_key);
+$tables_auxiliaires['spip_documents_articles'] = array(
+ 'field' => &$spip_documents_articles,
+ 'key' => &$spip_documents_articles_key);
+$tables_auxiliaires['spip_documents_rubriques'] = array(
+ 'field' => &$spip_documents_rubriques,
+ 'key' => &$spip_documents_rubriques_key);
+$tables_auxiliaires['spip_documents_breves'] = array(
+ 'field' => &$spip_documents_breves,
+ 'key' => &$spip_documents_breves_key);
+$tables_auxiliaires['spip_mots_articles'] = array(
+ 'field' => &$spip_mots_articles,
+ 'key' => &$spip_mots_articles_key);
+$tables_auxiliaires['spip_mots_breves'] = array(
+ 'field' => &$spip_mots_breves,
+ 'key' => &$spip_mots_breves_key);
+$tables_auxiliaires['spip_mots_rubriques'] = array(
+ 'field' => &$spip_mots_rubriques,
+ 'key' => &$spip_mots_rubriques_key);
+$tables_auxiliaires['spip_mots_syndic'] = array(
+ 'field' => &$spip_mots_syndic,
+ 'key' => &$spip_mots_syndic_key);
+$tables_auxiliaires['spip_mots_forum'] = array(
+ 'field' => &$spip_mots_forum,
+ 'key' => &$spip_mots_forum_key);
+$tables_auxiliaires['spip_mots_documents'] = array(
+ 'field' => &$spip_mots_documents,
+ 'key' => &$spip_mots_documents_key);
+$tables_auxiliaires['spip_meta'] = array(
+ 'field' => &$spip_meta,
+ 'key' => &$spip_meta_key);
+$tables_auxiliaires['spip_versions'] = array(
+ 'field' => &$spip_versions,
+ 'key' => &$spip_versions_key);
+$tables_auxiliaires['spip_versions_fragments'] = array(
+ 'field' => &$spip_versions_fragments,
+ 'key' => &$spip_versions_fragments_key);
+?>