--- /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;
+
+// Ce fichier ne sera execute qu'une fois
+if (defined('_ECRIRE_INC_AUXBASE')) return;
+define('_ECRIRE_INC_AUXBASE', "1");
+
+$spip_petitions = array(
+ "id_article" => "BIGINT (21) DEFAULT '0' NOT NULL",
+ "email_unique" => "CHAR (3) NOT NULL",
+ "site_obli" => "CHAR (3) NOT NULL",
+ "site_unique" => "CHAR (3) NOT NULL",
+ "message" => "CHAR (3) NOT NULL",
+ "texte" => "LONGBLOB NOT NULL",
+ "maj" => "TIMESTAMP");
+
+$spip_petitions_key = array(
+ "PRIMARY KEY" => "id_article");
+
+$spip_visites_temp = array(
+ "ip" => "INT UNSIGNED NOT NULL",
+ "type" => "ENUM ('article', 'rubrique', 'breve', 'autre') NOT NULL",
+ "id_objet" => "INT UNSIGNED NOT NULL",
+ "maj" => "TIMESTAMP");
+
+$spip_visites_temp_key = array(
+ "PRIMARY KEY" => "type, id_objet, ip");
+
+$spip_visites = array(
+ "date" => "DATE NOT NULL",
+ "visites" => "INT UNSIGNED 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 NOT NULL",
+ "maj" => "TIMESTAMP");
+
+$spip_visites_articles_key = array(
+ "PRIMARY KEY" => "date, id_article");
+
+$spip_referers_temp = array(
+ "ip" => "INT UNSIGNED NOT NULL",
+ "referer" => "VARCHAR (255) NOT NULL",
+ "referer_md5" => "BIGINT UNSIGNED NOT NULL",
+ "type" => "ENUM ('article', 'rubrique', 'breve', 'autre') NOT NULL",
+ "id_objet" => "INT UNSIGNED NOT NULL",
+ "maj" => "TIMESTAMP");
+
+$spip_referers_temp_key = array(
+ "PRIMARY KEY" => "type, id_objet, referer_md5, ip");
+
+$spip_referers = array(
+ "referer_md5" => "BIGINT UNSIGNED NOT NULL",
+ "date" => "DATE NOT NULL",
+ "referer" => "VARCHAR (255) NOT NULL",
+ "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) 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(
+ "KEY id_auteur" => "id_auteur",
+ "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(
+ "KEY id_auteur" => "id_auteur",
+ "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) NOT NULL");
+
+$spip_auteurs_messages_key = array(
+ "KEY id_auteur" => "id_auteur",
+ "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");
+
+$spip_documents_articles_key = array(
+ "KEY id_document" => "id_document",
+ "KEY id_article" => "id_article");
+
+$spip_documents_rubriques = array(
+ "id_document" => "BIGINT (21) DEFAULT '0' NOT NULL",
+ "id_rubrique" => "BIGINT (21) DEFAULT '0' NOT NULL");
+
+$spip_documents_rubriques_key = array(
+ "KEY id_document" => "id_document",
+ "KEY id_rubrique" => "id_rubrique");
+
+$spip_documents_breves = array(
+ "id_document" => "BIGINT (21) DEFAULT '0' NOT NULL",
+ "id_breve" => "BIGINT (21) DEFAULT '0' NOT NULL");
+
+$spip_documents_breves_key = array(
+ "KEY id_document" => "id_document",
+ "KEY id_breve" => "id_breve");
+
+$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(
+ "KEY id_mot" => "id_mot",
+ "KEY id_article" => "id_article");
+
+$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(
+ "KEY id_mot" => "id_mot",
+ "KEY id_breve" => "id_breve");
+
+$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(
+ "KEY id_mot" => "id_mot",
+ "KEY id_rubrique" => "id_rubrique");
+
+$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(
+ "KEY id_mot" => "id_mot",
+ "KEY id_syndic" => "id_syndic");
+
+$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(
+ "KEY id_mot" => "id_mot",
+ "KEY id_forum" => "id_forum");
+
+$spip_meta = array(
+ "nom" => "VARCHAR (255) NOT NULL",
+ "valeur" => "VARCHAR (255) DEFAULT ''",
+ "maj" => "TIMESTAMP");
+
+$spip_meta_key = array(
+ "PRIMARY KEY" => "nom");
+
+$spip_index_articles = array(
+ "`hash`" => "BIGINT UNSIGNED NOT NULL",
+ "points" => "INT UNSIGNED DEFAULT '0' NOT NULL",
+ "id_article" => "INT UNSIGNED NOT NULL");
+
+$spip_index_articles_key = array(
+ "KEY `hash`" => "`hash`",
+ "KEY id_article" => "id_article");
+
+$spip_index_auteurs = array(
+ "`hash`" => "BIGINT UNSIGNED NOT NULL",
+ "points" => "INT UNSIGNED DEFAULT '0' NOT NULL",
+ "id_auteur" => "INT UNSIGNED NOT NULL");
+
+$spip_index_auteurs_key = array(
+ "KEY `hash`" => "`hash`",
+ "KEY id_auteur" => "id_auteur");
+
+$spip_index_breves = array(
+ "`hash`" => "BIGINT UNSIGNED NOT NULL",
+ "points" => "INT UNSIGNED DEFAULT '0' NOT NULL",
+ "id_breve" => "INT UNSIGNED NOT NULL");
+
+$spip_index_breves_key = array(
+ "KEY `hash`" => "`hash`",
+ "KEY id_breve" => "id_breve");
+
+$spip_index_mots = array(
+ "`hash`" => "BIGINT UNSIGNED NOT NULL",
+ "points" => "INT UNSIGNED DEFAULT '0' NOT NULL",
+ "id_mot" => "INT UNSIGNED NOT NULL");
+
+$spip_index_mots_key = array(
+ "KEY `hash`" => "`hash`",
+ "KEY id_mot" => "id_mot");
+
+$spip_index_rubriques = array(
+ "`hash`" => "BIGINT UNSIGNED NOT NULL",
+ "points" => "INT UNSIGNED DEFAULT '0' NOT NULL",
+ "id_rubrique" => "INT UNSIGNED NOT NULL");
+
+$spip_index_rubriques_key = array(
+ "KEY `hash`" => "`hash`",
+ "KEY id_rubrique" => "id_rubrique");
+
+$spip_index_syndic = array(
+ "`hash`" => "BIGINT UNSIGNED NOT NULL",
+ "points" => "INT UNSIGNED DEFAULT '0' NOT NULL",
+ "id_syndic" => "INT UNSIGNED NOT NULL");
+
+$spip_index_syndic_key = array(
+ "KEY `hash`" => "`hash`",
+ "KEY id_syndic" => "id_syndic");
+
+$spip_index_signatures = array(
+ "`hash`" => "BIGINT UNSIGNED NOT NULL",
+ "points" => "INT UNSIGNED DEFAULT '0' NOT NULL",
+ "id_signature" => "INT UNSIGNED NOT NULL");
+
+$spip_index_signatures_key = array(
+ "KEY `hash`" => "`hash`",
+ "KEY id_signature" => "id_signature");
+
+$spip_index_forum = array(
+ "`hash`" => "BIGINT UNSIGNED NOT NULL",
+ "points" => "INT UNSIGNED DEFAULT '0' NOT NULL",
+ "id_forum" => "INT UNSIGNED NOT NULL");
+
+$spip_index_forum_key = array(
+ "KEY `hash`" => "`hash`",
+ "KEY id_forum" => "id_forum");
+
+$spip_index_dico = array(
+ "`hash`" => "BIGINT UNSIGNED NOT NULL",
+ "dico" => "VARCHAR (30) NOT NULL");
+
+$spip_index_dico_key = array(
+ "PRIMARY KEY" => "dico");
+
+$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" => "bigint(21) NOT NULL",
+ "titre_version" => "text DEFAULT '' NOT NULL",
+ "permanent" => "char(3) NOT NULL",
+ "champs" => "text NOT NULL");
+
+$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 NOT NULL");
+
+$spip_versions_fragments_key = array(
+ "PRIMARY KEY" => "id_article, id_fragment, version_min");
+
+$spip_caches = array(
+ "fichier" => "char (64) NOT NULL",
+ "id" => "char (64) NOT NULL",
+ // i=par id, t=timer, x=suppression
+ "type" => "CHAR (1) DEFAULT 'i' NOT NULL",
+ "taille" => "integer DEFAULT '0' NOT NULL");
+$spip_caches_key = array(
+ "PRIMARY KEY" => "fichier, id",
+ "KEY fichier" => "fichier",
+ "KEY id" => "id");
+
+$spip_ortho_cache = array(
+ "lang" => "VARCHAR(10) NOT NULL",
+ "mot" => "VARCHAR(255) BINARY NOT NULL",
+ "ok" => "TINYINT NOT NULL",
+ "suggest" => "BLOB NOT NULL",
+ "maj" => "TIMESTAMP");
+$spip_ortho_cache_key = array(
+ "PRIMARY KEY" => "lang, mot",
+ "KEY maj" => "maj");
+
+$spip_ortho_dico = array(
+ "lang" => "VARCHAR(10) NOT NULL",
+ "mot" => "VARCHAR(255) BINARY NOT NULL",
+ "id_auteur" => "BIGINT UNSIGNED NOT NULL",
+ "maj" => "TIMESTAMP");
+$spip_ortho_dico_key = array(
+ "PRIMARY KEY" => "lang, mot",);
+
+
+global $tables_auxiliaires;
+
+$tables_auxiliaires =
+ array(
+ 'spip_petitions' => array('field' => &$spip_petitions,
+ 'key' => &$spip_petitions_key),
+ 'spip_visites_temp' => array('field' => &$spip_visites_temp,
+ 'key' => &$spip_visites_temp_key),
+ 'spip_visites' => array('field' => &$spip_visites,
+ 'key' => &$spip_visites_key),
+ 'spip_visites_articles' => array('field' => &$spip_visites_articles,
+ 'key' => &$spip_visites_articles_key),
+ 'spip_referers_temp' => array('field' => &$spip_referers_temp,
+ 'key' => &$spip_referers_temp_key),
+ 'spip_referers' => array('field' => &$spip_referers,
+ 'key' => &$spip_referers_key),
+ 'spip_referers_articles' => array('field' => &$spip_referers_articles,
+ 'key' => &$spip_referers_articles_key),
+ 'spip_auteurs_articles' => array('field' => &$spip_auteurs_articles,
+ 'key' => &$spip_auteurs_articles_key),
+ 'spip_auteurs_rubriques' => array('field' => &$spip_auteurs_rubriques,
+ 'key' => &$spip_auteurs_rubriques_key),
+ 'spip_auteurs_messages' => array('field' => &$spip_auteurs_messages,
+ 'key' => &$spip_auteurs_messages_key),
+ 'spip_documents_articles' => array('field' => &$spip_documents_articles,
+ 'key' => &$spip_documents_articles_key),
+ 'spip_documents_rubriques' => array('field' => &$spip_documents_rubriques,
+ 'key' => &$spip_documents_rubriques_key),
+ 'spip_documents_breves' => array('field' => &$spip_documents_breves,
+ 'key' => &$spip_documents_breves_key),
+ 'spip_mots_articles' => array('field' => &$spip_mots_articles,
+ 'key' => &$spip_mots_articles_key),
+ 'spip_mots_breves' => array('field' => &$spip_mots_breves,
+ 'key' => &$spip_mots_breves_key),
+ 'spip_mots_rubriques' => array('field' => &$spip_mots_rubriques,
+ 'key' => &$spip_mots_rubriques_key),
+ 'spip_mots_syndic' => array('field' => &$spip_mots_syndic,
+ 'key' => &$spip_mots_syndic_key),
+ 'spip_mots_forum' => array('field' => &$spip_mots_forum,
+ 'key' => &$spip_mots_forum_key),
+ 'spip_meta' => array('field' => &$spip_meta,
+ 'key' => &$spip_meta_key),
+ 'spip_index_articles' => array('field' => &$spip_index_articles,
+ 'key' => &$spip_index_articles_key),
+ 'spip_index_auteurs' => array('field' => &$spip_index_auteurs,
+ 'key' => &$spip_index_auteurs_key),
+ 'spip_index_breves' => array('field' => &$spip_index_breves,
+ 'key' => &$spip_index_breves_key),
+ 'spip_index_mots' => array('field' => &$spip_index_mots,
+ 'key' => &$spip_index_mots_key),
+ 'spip_index_rubriques' => array('field' => &$spip_index_rubriques,
+ 'key' => &$spip_index_rubriques_key),
+ 'spip_index_syndic' => array('field' => &$spip_index_syndic,
+ 'key' => &$spip_index_syndic_key),
+ 'spip_index_signatures' => array('field' => &$spip_index_signatures,
+ 'key' => &$spip_index_signatures_key),
+ 'spip_index_forum' => array('field' => &$spip_index_forum,
+ 'key' => &$spip_index_forum_key),
+ 'spip_index_dico' => array('field' => &$spip_index_dico,
+ 'key' => &$spip_index_dico_key),
+ 'spip_versions' => array('field' => &$spip_versions,
+ 'key' => &$spip_versions_key),
+ 'spip_versions_fragments' => array('field' => &$spip_versions_fragments,
+ 'key' => &$spip_versions_fragments_key),
+ 'spip_caches' => array('field' => &$spip_caches,
+ 'key' => &$spip_caches_key),
+ 'spip_ortho_cache' => array('field' => &$spip_ortho_cache,
+ 'key' => &$spip_ortho_cache_key),
+ 'spip_ortho_dico' => array('field' => &$spip_ortho_dico,
+ 'key' => &$spip_ortho_dico_key)
+ );
+
+
+//
+// tableau des tables de relations,
+// Ex: gestion du critere {id_mot} dans la boucle(ARTICLES)
+// transposee en tables_jointures pour le code moderne
+//
+global $tables_jointures;
+
+$tables_jointures['spip_articles']['id_mot']='mots_articles';
+$tables_jointures['spip_articles']['id_auteur']='auteurs_articles';
+$tables_jointures['spip_articles']['id_document']='documents_articles';
+
+$tables_jointures['spip_auteurs']['id_article']='auteurs_articles';
+
+$tables_jointures['spip_breves']['id_mot']='mots_breves';
+$tables_jointures['spip_breves']['id_document']='documents_breves';
+
+$tables_jointures['spip_documents']['id_article']='documents_articles';
+$tables_jointures['spip_documents']['id_rubrique']='documents_rubriques';
+$tables_jointures['spip_documents']['id_breve']='documents_breves';
+
+$tables_jointures['spip_forums']['id_mot']='mots_forum';
+
+$tables_jointures['spip_mots']['id_article']='mots_articles';
+$tables_jointures['spip_mots']['id_breve']='mots_breves';
+$tables_jointures['spip_mots']['id_forum']='mots_forum';
+$tables_jointures['spip_mots']['id_rubrique']='mots_rubriques';
+$tables_jointures['spip_mots']['id_syndic']='mots_syndic';
+
+$tables_jointures['spip_groupes_mots']['id_groupe']='mots';
+
+$tables_jointures['spip_rubriques']['id_mot']='mots_rubriques';
+$tables_jointures['spip_rubriques']['id_document']='documents_rubriques';
+
+$tables_jointures['spip_syndication']['id_mot']='mots_syndic';
+
+?>