Subversion Repositories Sites.tela-botanica.org

Rev

Blame | Last modification | View Log | RSS feed

<?php

/***************************************************************************\
 *  SPIP, Systeme de publication pour l'internet                           *
 *                                                                         *
 *  Copyright (c) 2001-2005                                                *
 *  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.   *
\***************************************************************************/


// 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_documents_syndic = array(
                "id_document"   => "BIGINT (21) DEFAULT '0' NOT NULL",
                "id_syndic"     => "BIGINT (21) DEFAULT '0' NOT NULL",
                "id_syndic_article"     => "BIGINT (21) DEFAULT '0' NOT NULL"
                );

$spip_documents_syndic_key = array(
                "KEY id_document"       => "id_document",
                "KEY id_syndic" => "id_syndic",
                "KEY id_syndic_article" => "id_syndic_article");

$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_mots_documents = array(
                "id_mot"        => "BIGINT (21) DEFAULT '0' NOT NULL",
                "id_document"   => "BIGINT (21) DEFAULT '0' NOT NULL");

$spip_mots_documents_key = array(
                "KEY id_mot"    => "id_mot",
                "KEY id_document"       => "id_document");

$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_documents = array(
                "`hash`"        => "BIGINT UNSIGNED NOT NULL",
                "points"        => "INT UNSIGNED DEFAULT '0' NOT NULL",
                "id_document"   => "INT UNSIGNED NOT NULL");

$spip_index_documents_key = array(
                "KEY `hash`"    => "`hash`",
                "KEY id_document"       => "id_document");

$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_documents_syndic' => array('field' => &$spip_documents_syndic,
                                    'key' => &$spip_documents_syndic_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_mots_documents' => array('field' => &$spip_mots_documents,
                              'key' => &$spip_mots_documents_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_documents' => array('field' => &$spip_index_documents,
                               'key' => &$spip_index_documents_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)
        );

?>