Subversion Repositories Sites.tela-botanica.org

Rev

Rev 609 | Blame | Compare with Previous | 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_SERIALBASE")) return;
define("_ECRIRE_INC_SERIALBASE", "1");


$spip_articles = array(
                "id_article"    => "bigint(21) NOT NULL",
                "surtitre"      => "text NOT NULL",
                "titre" => "text NOT NULL",
                "soustitre"     => "text NOT NULL",
                "id_rubrique"   => "bigint(21) DEFAULT '0' NOT NULL",
                "descriptif"    => "text NOT NULL",
                "chapo" => "mediumtext NOT NULL",
                "texte" => "longblob NOT NULL",
                "ps"    => "mediumtext NOT NULL",
                "date"  => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
                "statut"        => "varchar(10) DEFAULT '0' NOT NULL",
                "id_secteur"    => "bigint(21) DEFAULT '0' NOT NULL",
                "maj"   => "TIMESTAMP",
                "export"        => "VARCHAR(10) DEFAULT 'oui'",
                "date_redac"    => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
                "visites"       => "INTEGER DEFAULT '0' NOT NULL",
                "referers"      => "INTEGER DEFAULT '0' NOT NULL",
                "popularite"    => "DOUBLE DEFAULT '0' NOT NULL",
                "accepter_forum"        => "CHAR(3) NOT NULL",
                "auteur_modif"  => "bigint(21) DEFAULT '0' NOT NULL",
                "date_modif"    => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
                "lang"          => "VARCHAR(10) DEFAULT '' NOT NULL",
                "langue_choisie"        => "VARCHAR(3) DEFAULT 'non'",
                "id_trad"       => "bigint(21) DEFAULT '0' NOT NULL",
                "extra"         => "longblob NULL",
                "idx"           => "ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL",
                "id_version"    => "int unsigned DEFAULT '0' NOT NULL",
                "nom_site"      => "tinytext NOT NULL",
                "url_site"      => "VARCHAR(255) NOT NULL",
                "url_propre" => "VARCHAR(255) NOT NULL");

$spip_articles_key = array(
                "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");

$spip_auteurs = array(
                "id_auteur"     => "bigint(21) NOT NULL",
                "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",
                "pass"  => "tinytext NOT NULL",
                "low_sec"       => "tinytext NOT NULL",
                "statut"        => "VARCHAR(255) NOT NULL",
                "maj"   => "TIMESTAMP",
                "pgp"   => "BLOB NOT NULL",
                "htpass"        => "tinyblob NOT NULL",
                "en_ligne"      => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
                "imessage"      => "VARCHAR(3) NOT NULL",
                "messagerie"    => "VARCHAR(3) NOT NULL",
                "alea_actuel"   => "tinytext NOT NULL",
                "alea_futur"    => "tinytext NOT NULL",
                "prefs" => "tinytext NOT NULL",
                "cookie_oubli"  => "tinytext NOT NULL",
                "source"        => "VARCHAR(10) DEFAULT 'spip' NOT NULL",
                "lang"  => "VARCHAR(10) DEFAULT '' NOT NULL",
                "idx"           => "ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL",
                "url_propre" => "VARCHAR(255) NOT NULL",
                "extra" => "longblob NULL");

$spip_auteurs_key = array(
                "PRIMARY KEY"   => "id_auteur",
                "KEY login"     => "login",
                "KEY statut"    => "statut",
                "KEY lang"      => "lang",
                "KEY idx"       => "idx",
                "KEY en_ligne"  => "en_ligne");

$spip_breves = array(
                "id_breve"      => "bigint(21) NOT NULL",
                "date_heure"    => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
                "titre" => "text NOT NULL",
                "texte" => "longblob NOT NULL",
                "lien_titre"    => "text NOT NULL",
                "lien_url"      => "text NOT NULL",
                "statut"        => "varchar(6) NOT NULL",
                "id_rubrique"   => "bigint(21) DEFAULT '0' NOT NULL",
                "lang"  => "VARCHAR(10) DEFAULT '' NOT NULL",
                "langue_choisie"        => "VARCHAR(3) DEFAULT 'non'",
                "maj"   => "TIMESTAMP",
                "idx"           => "ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL",
                "extra" => "longblob NULL",
                "url_propre" => "VARCHAR(255) NOT NULL");

$spip_breves_key = array(
                "PRIMARY KEY"   => "id_breve",
                "KEY idx"       => "idx",
                "KEY id_rubrique"       => "id_rubrique",
                "KEY url_propre"        => "url_propre");

$spip_messages = array(
                "id_message"    => "bigint(21) NOT NULL",
                "titre" => "text NOT NULL",
                "texte" => "longblob NOT NULL",
                "type"  => "varchar(6) NOT NULL",
                "date_heure"    => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
                "date_fin"      => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
                "rv"    => "varchar(3) NOT NULL",
                "statut"        => "varchar(6) NOT NULL",
                "id_auteur"     => "bigint(21) NOT NULL",
                "maj"   => "TIMESTAMP");

$spip_messages_key = array(
                "PRIMARY KEY"   => "id_message",
                "KEY id_auteur" => "id_auteur");

$spip_mots = array(
                "id_mot"        => "bigint(21) NOT NULL",
                "type"  => "VARCHAR(100) NOT NULL",
                "titre" => "text NOT NULL",
                "descriptif"    => "text NOT NULL",
                "texte" => "longblob NOT NULL",
                "id_groupe"     => "bigint(21) NOT NULL",
                "extra" => "longblob NULL",
                "idx"           => "ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL",
                "url_propre" => "VARCHAR(255) NOT NULL",
                "maj"   => "TIMESTAMP");

$spip_mots_key = array(
                "PRIMARY KEY"   => "id_mot",
                "KEY idx"       => "idx",
                "KEY type"      => "type",
                "KEY url_propre"        => "url_propre");

$spip_groupes_mots = array(
                "id_groupe"     => "bigint(21) NOT NULL",
                "titre" => "text NOT NULL",
                "descriptif"    => "text NOT NULL",
                "texte" => "longblob NOT NULL",
                "unseul"        => "varchar(3) NOT NULL",
                "obligatoire"   => "varchar(3) NOT NULL",
                "articles"      => "varchar(3) NOT NULL",
                "breves"        => "varchar(3) NOT NULL",
                "rubriques"     => "varchar(3) NOT NULL",
                "syndic"        => "varchar(3) NOT NULL",
                "minirezo"      => "varchar(3) NOT NULL",
                "comite"        => "varchar(3) NOT NULL",
                "forum" => "varchar(3) NOT NULL",
                "maj"   => "TIMESTAMP");

$spip_groupes_mots_key = array(
                "PRIMARY KEY"   => "id_groupe");

$spip_rubriques = array(
                "id_rubrique"   => "bigint(21) NOT NULL",
                "id_parent"     => "bigint(21) DEFAULT '0' NOT NULL",
                "titre" => "text NOT NULL",
                "descriptif"    => "text NOT NULL",
                "texte" => "longblob NOT NULL",
                "id_secteur"    => "bigint(21) DEFAULT '0' NOT NULL",
                "maj"   => "TIMESTAMP",
                "export"        => "VARCHAR(10) DEFAULT 'oui'",
                "id_import"     => "BIGINT DEFAULT '0'",
                "statut"        => "VARCHAR(10) NOT NULL",
                "date"  => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
                "lang"  => "VARCHAR(10) DEFAULT '' NOT NULL",
                "langue_choisie"        => "VARCHAR(3) DEFAULT 'non'",
                "idx"           => "ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL",
                "extra" => "longblob NULL",
                "url_propre" => "VARCHAR(255) NOT NULL",
                "statut_tmp"    => "VARCHAR(10) NOT NULL",
                "date_tmp"      => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL"
                );

$spip_rubriques_key = array(
                "PRIMARY KEY"   => "id_rubrique",
                "KEY lang"      => "lang",
                "KEY idx"       => "idx",
                "KEY id_parent" => "id_parent",
                "KEY url_propre"        => "url_propre");

$spip_documents = array(
                "id_document"   => "bigint(21) NOT NULL",
                "id_vignette"   => "bigint(21) DEFAULT '0' NOT NULL",
                "id_type"       => "bigint(21) DEFAULT '0' NOT NULL",
                "titre" => "text NOT NULL",
                "date"  => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
                "descriptif"    => "text NOT NULL",
                "fichier"       => "varchar(255) NOT NULL",
                "taille"        => "integer NOT NULL",
                "largeur"       => "integer NOT NULL",
                "hauteur"       => "integer NOT NULL",
                "mode"  => "ENUM('vignette', 'document') NOT NULL",
                "inclus"        => "VARCHAR(3) DEFAULT 'non'",
                "distant"       => "VARCHAR(3) DEFAULT 'non'",
                "idx"           => "ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL",
                "maj"   => "TIMESTAMP");

$spip_documents_key = array(
                "PRIMARY KEY"   => "id_document",
                "KEY id_vignette"       => "id_vignette",
                "KEY mode"      => "mode",
                "KEY id_type"   => "id_type");

$spip_types_documents = array(
                "id_type"       => "bigint(21) NOT NULL",
                "titre" => "text NOT NULL",
                "descriptif"    => "text NOT NULL",
                "extension"     => "varchar(10) NOT NULL",
                "mime_type"     => "varchar(100) NOT NULL",
                "inclus"        => "ENUM('non', 'image', 'embed') NOT NULL DEFAULT 'non'",
                "upload"        => "ENUM('oui', 'non') NOT NULL DEFAULT 'oui'",
                "maj"   => "TIMESTAMP");

$spip_types_documents_key = array(
                "PRIMARY KEY"   => "id_type",
                "UNIQUE extension"      => "extension",
                "KEY inclus"    => "inclus");

$spip_syndic = array(
                "id_syndic"     => "bigint(21) NOT NULL",
                "id_rubrique"   => "bigint(21) DEFAULT '0' NOT NULL",
                "id_secteur"    => "bigint(21) DEFAULT '0' NOT NULL",
                "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') DEFAULT '' NOT NULL",
                "maj"   => "TIMESTAMP",
                "syndication"   => "VARCHAR(3) NOT NULL",
                "statut"        => "VARCHAR(10) NOT NULL",
                "date"  => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
                "date_syndic"   => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
                "date_index"    => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
                "extra"                 => "longblob NULL",
                "moderation"    => "VARCHAR(3) DEFAULT 'non'",
                "miroir"        => "VARCHAR(3) DEFAULT 'non'",
                "oubli" => "VARCHAR(3) DEFAULT 'non'"
);

$spip_syndic_key = array(
                "PRIMARY KEY"   => "id_syndic",
                "KEY id_rubrique"       => "id_rubrique",
                "KEY id_secteur"        => "id_secteur",
                "KEY idx"               => "idx",
                "KEY statut"    => "statut, date_syndic");

$spip_syndic_articles = array(
                "id_syndic_article"     => "bigint(21) NOT NULL",
                "id_syndic"     => "bigint(21) DEFAULT '0' NOT NULL",
                "titre" => "text NOT NULL",
                "url"   => "VARCHAR(255) NOT NULL",
                "date"  => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
                "lesauteurs"    => "text NOT NULL",
                "maj"   => "TIMESTAMP",
                "statut"        => "VARCHAR(10) NOT NULL",
                "descriptif"    => "blob NOT NULL");

$spip_syndic_articles_key = array(
                "PRIMARY KEY"   => "id_syndic_article",
                "KEY id_syndic" => "id_syndic",
                "KEY statut"    => "statut",
                "KEY url"       => "url");

$spip_forum = array(
                "id_forum"      => "bigint(21) NOT NULL",
                "id_parent"     => "bigint(21) DEFAULT '0' NOT NULL",
                "id_thread"     => "bigint(21) DEFAULT '0' NOT NULL",
                "id_rubrique"   => "bigint(21) DEFAULT '0' NOT NULL",
                "id_article"    => "bigint(21) DEFAULT '0' NOT NULL",
                "id_breve"      => "bigint(21) DEFAULT '0' NOT NULL",
                "date_heure"    => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
                "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",
                "idx"           => "ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL",
                "ip"    => "varchar(16)",
                "maj"   => "TIMESTAMP",
                "id_auteur"     => "BIGINT DEFAULT '0' NOT NULL",
                "id_message"    => "bigint(21) DEFAULT '0' NOT NULL",
                "id_syndic"     => "bigint(21) DEFAULT '0' NOT NULL");

$spip_forum_key = array(
                "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");

$spip_signatures = array(
                "id_signature"  => "bigint(21) NOT NULL",
                "id_article"    => "bigint(21) DEFAULT '0' NOT NULL",
                "date_time"     => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
                "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",
                "idx"           => "ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL",
                "maj"   => "TIMESTAMP");

$spip_signatures_key = array(
                "PRIMARY KEY"   => "id_signature",
                "KEY id_article"        => "id_article",
                "KEY idx"               => "idx",
                "KEY statut" => "statut");

global $tables_principales;

/// Attention: mes_fonctions peut avoir deja defini cette variable
/// il faut donc rajouter, mais pas reinitialiser

$tables_principales['spip_articles'] =
        array('field' => &$spip_articles, 'key' => &$spip_articles_key);
$tables_principales['spip_auteurs']  =
        array('field' => &$spip_auteurs, 'key' => &$spip_auteurs_key);
$tables_principales['spip_breves']   =
        array('field' => &$spip_breves, 'key' => &$spip_breves_key);
$tables_principales['spip_messages'] =
        array('field' => &$spip_messages, 'key' => &$spip_messages_key);
$tables_principales['spip_mots']     =
        array('field' => &$spip_mots, 'key' => &$spip_mots_key);
$tables_principales['spip_groupes_mots'] =
        array('field' => &$spip_groupes_mots, 'key' => &$spip_groupes_mots_key);
$tables_principales['spip_rubriques'] =
        array('field' => &$spip_rubriques, 'key' => &$spip_rubriques_key);
$tables_principales['spip_documents'] =
        array('field' => &$spip_documents,  'key' => &$spip_documents_key);
$tables_principales['spip_types_documents']     =
        array('field' => &$spip_types_documents, 'key' => &$spip_types_documents_key);
$tables_principales['spip_syndic'] =
        array('field' => &$spip_syndic, 'key' => &$spip_syndic_key);
$tables_principales['spip_syndic_articles']     =
        array('field' => &$spip_syndic_articles, 'key' => &$spip_syndic_articles_key);
$tables_principales['spip_forum'] =
        array('field' => &$spip_forum,  'key' => &$spip_forum_key);
$tables_principales['spip_signatures'] =
        array('field' => &$spip_signatures, 'key' => &$spip_signatures_key);

?>