File "auxiliaires.php"
Full path: /home/meharicl/www/ecrire/maj/vieille_base/1915/auxiliaires.php
File
size: 12.24 B
MIME-type: text/x-php
Charset: utf-8
Download Open Edit Advanced Editor Back
<?php
/***************************************************************************\
* SPIP, Systeme de publication pour l'internet *
* *
* Copyright (c) 2001-2016 *
* 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) 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 = 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 = 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(
"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) NOT NULL");
$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");
$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(
"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 ''",
"maj" => "TIMESTAMP");
$spip_meta_key = array(
"PRIMARY KEY" => "nom");
$spip_index = array(
"`hash`" => "BIGINT UNSIGNED NOT NULL",
"points" => "INT UNSIGNED DEFAULT '0' NOT NULL",
"id_objet" => "INT UNSIGNED NOT NULL",
"id_table" => "TINYINT UNSIGNED NOT NULL" );
$spip_index_key = array(
"KEY `hash`" => "`hash`",
"KEY id_objet" => "id_objet",
"KEY id_table" => "id_table");
$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['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_index'] = array(
'field' => &$spip_index,
'key' => &$spip_index_key);
$tables_auxiliaires['spip_index_dico'] = array(
'field' => &$spip_index_dico,
'key' => &$spip_index_dico_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);
$tables_auxiliaires['spip_caches'] = array(
'field' => &$spip_caches,
'key' => &$spip_caches_key);
$tables_auxiliaires['spip_ortho_cache'] = array(
'field' => &$spip_ortho_cache,
'key' => &$spip_ortho_cache_key);
$tables_auxiliaires['spip_ortho_dico'] = array(
'field' => &$spip_ortho_dico,
'key' => &$spip_ortho_dico_key);
//
// tableau des tables de jointures
// Ex: gestion du critere {id_mot} dans la boucle(ARTICLES)
global $tables_jointures;
$tables_jointures['spip_articles'][]= 'mots_articles';
$tables_jointures['spip_articles'][]= 'auteurs_articles';
$tables_jointures['spip_articles'][]= 'documents_articles';
$tables_jointures['spip_articles'][]= 'mots';
$tables_jointures['spip_articles'][]= 'signatures';
$tables_jointures['spip_auteurs'][]= 'auteurs_articles';
$tables_jointures['spip_auteurs'][]= 'mots';
$tables_jointures['spip_breves'][]= 'mots_breves';
$tables_jointures['spip_breves'][]= 'documents_breves';
$tables_jointures['spip_breves'][]= 'mots';
$tables_jointures['spip_documents'][]= 'documents_articles';
$tables_jointures['spip_documents'][]= 'documents_rubriques';
$tables_jointures['spip_documents'][]= 'documents_breves';
$tables_jointures['spip_documents'][]= 'mots_documents';
$tables_jointures['spip_documents'][]= 'types_documents';
$tables_jointures['spip_documents'][]= 'mots';
$tables_jointures['spip_forum'][]= 'mots_forum';
$tables_jointures['spip_forum'][]= 'mots';
$tables_jointures['spip_rubriques'][]= 'mots_rubriques';
$tables_jointures['spip_rubriques'][]= 'documents_rubriques';
$tables_jointures['spip_rubriques'][]= 'mots';
$tables_jointures['spip_syndic'][]= 'mots_syndic';
$tables_jointures['spip_syndic'][]= 'mots';
$tables_jointures['spip_syndic_articles'][]= 'syndic';
$tables_jointures['spip_syndic_articles'][]= 'mots';
$tables_jointures['spip_mots'][]= 'mots_articles';
$tables_jointures['spip_mots'][]= 'mots_breves';
$tables_jointures['spip_mots'][]= 'mots_forum';
$tables_jointures['spip_mots'][]= 'mots_rubriques';
$tables_jointures['spip_mots'][]= 'mots_syndic';
$tables_jointures['spip_mots'][]= 'mots_documents';
$tables_jointures['spip_groupes_mots'][]= 'mots';
?>