File "inc_serialbase.php"
Full path: /home/meharicl/www/ecrire/maj/vieille_base/1813/inc_serialbase.php
File
size: 13.11 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;
// 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",
"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",
"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",
"0minirezo" => "varchar(3) NOT NULL",
"1comite" => "varchar(3) NOT NULL",
"6forum" => "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'",
"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) NOT NULL");
$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);
?>