X-Git-Url: http://git.cyclocoop.org/?p=velocampus%2Fweb%2Fwww.git;a=blobdiff_plain;f=www%2Fecrire%2Fbase%2Fserial.php;fp=www%2Fecrire%2Fbase%2Fserial.php;h=aad833482474e2f8c4d22cb5de678804e582d410;hp=0000000000000000000000000000000000000000;hb=80b4d3e85f78d402ed2e73f8f5d1bf4c19962eed;hpb=aaf970bf4cdaf76689ecc10609048e18d073820c

diff --git a/www/ecrire/base/serial.php b/www/ecrire/base/serial.php
new file mode 100644
index 0000000..aad8334
--- /dev/null
+++ b/www/ecrire/base/serial.php
@@ -0,0 +1,394 @@
+<?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;
+
+// http://doc.spip.org/@base_serial
+function base_serial(&$tables_principales){
+$spip_articles = array(
+		"id_article"	=> "bigint(21) NOT NULL",
+		"surtitre"	=> "text DEFAULT '' NOT NULL",
+		"titre"	=> "text DEFAULT '' NOT NULL",
+		"soustitre"	=> "text DEFAULT '' NOT NULL",
+		"id_rubrique"	=> "bigint(21) DEFAULT '0' NOT NULL",
+		"descriptif"	=> "text DEFAULT '' NOT NULL",
+		"chapo"	=> "mediumtext DEFAULT '' NOT NULL",
+		"texte"	=> "longtext DEFAULT '' NOT NULL",
+		"ps"	=> "mediumtext DEFAULT '' 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) DEFAULT '' 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"		=> "longtext NULL",
+		"id_version"	=> "int unsigned DEFAULT '0' NOT NULL",
+		"nom_site"	=> "tinytext DEFAULT '' NOT NULL",
+		"url_site"	=> "VARCHAR(255) DEFAULT '' NOT NULL",
+#		"url_propre" => "VARCHAR(255) DEFAULT '' 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_propre"	=> "url_propre"
+);
+$spip_articles_join = array(
+		"id_article"=>"id_article",
+		"id_rubrique"=>"id_rubrique");
+
+$spip_auteurs = array(
+		"id_auteur"	=> "bigint(21) NOT NULL",
+		"nom"	=> "text DEFAULT '' NOT NULL",
+		"bio"	=> "text DEFAULT '' NOT NULL",
+		"email"	=> "tinytext DEFAULT '' NOT NULL",
+		"nom_site"	=> "tinytext DEFAULT '' NOT NULL",
+		"url_site"	=> "text DEFAULT '' NOT NULL",
+		"login"	=> "VARCHAR(255) BINARY",
+		"pass"	=> "tinytext DEFAULT '' NOT NULL",
+		"low_sec"	=> "tinytext DEFAULT '' NOT NULL",
+		"statut"	=> "varchar(255)  DEFAULT '0' NOT NULL",
+		"webmestre"	=> "varchar(3)  DEFAULT 'non' NOT NULL",
+		"maj"	=> "TIMESTAMP",
+		"pgp"	=> "TEXT DEFAULT '' NOT NULL",
+		"htpass"	=> "tinytext DEFAULT '' NOT NULL",
+		"en_ligne"	=> "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
+		"imessage"	=> "VARCHAR(3)",
+		"messagerie"	=> "VARCHAR(3)",
+		"alea_actuel"	=> "tinytext",
+		"alea_futur"	=> "tinytext",
+		"prefs"	=> "tinytext",
+		"cookie_oubli"	=> "tinytext",
+		"source"	=> "VARCHAR(10) DEFAULT 'spip' NOT NULL",
+		"lang"	=> "VARCHAR(10) DEFAULT '' NOT NULL",
+#		"url_propre" => "VARCHAR(255)",
+		"extra"	=> "longtext NULL");
+
+$spip_auteurs_key = array(
+		"PRIMARY KEY"	=> "id_auteur",
+		"KEY login"	=> "login",
+		"KEY statut"	=> "statut",
+		"KEY en_ligne"	=> "en_ligne",
+#		"KEY url_propre"	=> "url_propre"
+);
+$spip_auteurs_join = array(
+		"id_auteur"=>"id_auteur",
+		"login"=>"login");
+
+
+$spip_breves = array(
+		"id_breve"	=> "bigint(21) NOT NULL",
+		"date_heure"	=> "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
+		"titre"	=> "text DEFAULT '' NOT NULL",
+		"texte"	=> "longtext DEFAULT '' NOT NULL",
+		"lien_titre"	=> "text DEFAULT '' NOT NULL",
+		"lien_url"	=> "text DEFAULT '' NOT NULL",
+		"statut"	=> "varchar(6)  DEFAULT '0' NOT NULL",
+		"id_rubrique"	=> "bigint(21) DEFAULT '0' NOT NULL",
+		"lang"	=> "VARCHAR(10) DEFAULT '' NOT NULL",
+		"langue_choisie"	=> "VARCHAR(3) DEFAULT 'non'",
+		"maj"	=> "TIMESTAMP",
+		"extra"	=> "longtext NULL",
+#		"url_propre" => "VARCHAR(255) DEFAULT '' NOT NULL"
+);
+
+$spip_breves_key = array(
+		"PRIMARY KEY"	=> "id_breve",
+		"KEY id_rubrique"	=> "id_rubrique",
+#		"KEY url_propre"	=> "url_propre"
+);
+$spip_breves_join = array(
+		"id_breve"=>"id_breve",
+		"id_rubrique"=>"id_rubrique");
+
+$spip_messages = array(
+		"id_message"	=> "bigint(21) NOT NULL",
+		"titre"	=> "text DEFAULT '' NOT NULL",
+		"texte"	=> "longtext DEFAULT '' NOT NULL",
+		"type"	=> "varchar(6) DEFAULT '' 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) DEFAULT '' NOT NULL",
+		"statut"	=> "varchar(6)  DEFAULT '0' 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",
+		"titre"	=> "text DEFAULT '' NOT NULL",
+		"descriptif"	=> "text DEFAULT '' NOT NULL",
+		"texte"	=> "longtext DEFAULT '' NOT NULL",
+		"id_groupe"	=> "bigint(21) DEFAULT 0 NOT NULL",
+		"type"	=> "text DEFAULT '' NOT NULL",
+		"extra"	=> "longtext NULL",
+#		"url_propre" => "VARCHAR(255) DEFAULT '' NOT NULL",
+		"maj"	=> "TIMESTAMP");
+
+$spip_mots_key = array(
+		"PRIMARY KEY"	=> "id_mot",
+#		"KEY url_propre"	=> "url_propre"
+);
+
+$spip_groupes_mots = array(
+		"id_groupe"	=> "bigint(21) NOT NULL",
+		"titre"	=> "text DEFAULT '' NOT NULL",
+		"descriptif"	=> "text DEFAULT '' NOT NULL",
+		"texte"	=> "longtext DEFAULT '' NOT NULL",
+		"unseul"	=> "varchar(3) DEFAULT '' NOT NULL",
+		"obligatoire"	=> "varchar(3) DEFAULT '' NOT NULL",
+		"tables_liees" => "text DEFAULT '' NOT NULL",
+		# suppression des champs a faire dans la maj
+		#"articles"	=> "varchar(3) DEFAULT '' NOT NULL",
+		#"breves"	=> "varchar(3) DEFAULT '' NOT NULL",
+		#"rubriques"	=> "varchar(3) DEFAULT '' NOT NULL",
+		#"syndic"	=> "varchar(3) DEFAULT '' NOT NULL",
+		"minirezo"	=> "varchar(3) DEFAULT '' NOT NULL",
+		"comite"	=> "varchar(3) DEFAULT '' NOT NULL",
+		"forum"	=> "varchar(3) DEFAULT '' 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 DEFAULT '' NOT NULL",
+		"descriptif"	=> "text DEFAULT '' NOT NULL",
+		"texte"	=> "longtext DEFAULT '' 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) DEFAULT '0' 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'",
+		"extra"	=> "longtext NULL",
+#		"url_propre" => "VARCHAR(255) DEFAULT '' NOT NULL",
+		"statut_tmp"	=> "varchar(10) DEFAULT '0' 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 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",
+		"extension"	=> "VARCHAR(10) DEFAULT '' NOT NULL",
+		"titre"	=> "text DEFAULT '' NOT NULL",
+		"date"	=> "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
+		"descriptif"	=> "text DEFAULT '' NOT NULL",
+		"fichier"	=> "varchar(255) DEFAULT '' NOT NULL",
+		"taille"	=> "integer",
+		"largeur"	=> "integer",
+		"hauteur"	=> "integer",
+		"mode"	=> "ENUM('vignette', 'image', 'document') DEFAULT 'document' NOT NULL",
+		"distant"	=> "VARCHAR(3) DEFAULT 'non'",
+		"maj"	=> "TIMESTAMP");
+
+$spip_documents_key = array(
+		"PRIMARY KEY"	=> "id_document",
+		"KEY id_vignette"	=> "id_vignette",
+		"KEY mode"	=> "mode",
+		"KEY extension"	=> "extension");
+$spip_documents_join = array(
+		"id_document"=>"id_document",
+		"extension"=>"extension");
+
+$spip_types_documents = array(
+		"extension"	=> "varchar(10) DEFAULT '' NOT NULL",
+		"titre"	=> "text DEFAULT '' NOT NULL",
+		"descriptif"	=> "text DEFAULT '' NOT NULL",
+		"mime_type"	=> "varchar(100) DEFAULT '' 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"	=> "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"	=> "text DEFAULT '' NOT NULL",
+		"url_site"	=> "text DEFAULT '' NOT NULL",
+		"url_syndic"	=> "text DEFAULT '' NOT NULL",
+		"descriptif"	=> "text DEFAULT '' NOT NULL",
+#		"url_propre"	=> "VARCHAR(255) DEFAULT '' NOT NULL",
+		"maj"	=> "TIMESTAMP",
+		"syndication"	=> "VARCHAR(3) DEFAULT '' NOT NULL",
+		"statut"	=> "varchar(10) DEFAULT '0' 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"			=> "longtext NULL",
+		"moderation"	=> "VARCHAR(3) DEFAULT 'non'",
+		"miroir"	=> "VARCHAR(3) DEFAULT 'non'",
+		"oubli"	=> "VARCHAR(3) DEFAULT 'non'",
+		"resume"	=> "VARCHAR(3) DEFAULT 'oui'"
+);
+
+$spip_syndic_key = array(
+		"PRIMARY KEY"	=> "id_syndic",
+		"KEY id_rubrique"	=> "id_rubrique",
+		"KEY id_secteur"	=> "id_secteur",
+		"KEY statut"	=> "statut, date_syndic",
+#		"KEY url_propre"	=> "url_propre"
+);
+$spip_syndic_join = array(
+		"id_syndic"=>"id_syndic",
+		"id_rubrique"=>"id_rubrique");
+		
+$spip_syndic_articles = array(
+		"id_syndic_article"	=> "bigint(21) NOT NULL",
+		"id_syndic"	=> "bigint(21) DEFAULT '0' NOT NULL",
+		"titre"	=> "text DEFAULT '' NOT NULL",
+		"url"	=> "VARCHAR(255) DEFAULT '' NOT NULL",
+		"date"	=> "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
+		"lesauteurs"	=> "text DEFAULT '' NOT NULL",
+		"maj"	=> "TIMESTAMP",
+		"statut"	=> "varchar(10) DEFAULT '0' NOT NULL",
+		"descriptif"	=> "text DEFAULT '' NOT NULL",
+		"lang"	=> "VARCHAR(10) DEFAULT '' NOT NULL",
+		"url_source" => "TINYTEXT DEFAULT '' NOT NULL",
+		"source" => "TINYTEXT DEFAULT '' NOT NULL",
+		"tags" => "TEXT DEFAULT '' NOT NULL");
+
+$spip_syndic_articles_key = array(
+		"PRIMARY KEY"	=> "id_syndic_article",
+		"KEY id_syndic"	=> "id_syndic",
+		"KEY statut"	=> "statut",
+		"KEY url"	=> "url");
+$spip_syndic_articles_join = array(
+		"id_syndic_article"=>"id_syndic_article",
+		"id_syndic"=>"id_syndic");
+
+$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",
+		"date_thread"	=> "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
+		"titre"	=> "text DEFAULT '' NOT NULL",
+		"texte"	=> "mediumtext DEFAULT '' NOT NULL",
+		"auteur"	=> "text DEFAULT '' NOT NULL",
+		"email_auteur"	=> "text DEFAULT '' NOT NULL",
+		"nom_site"	=> "text DEFAULT '' NOT NULL",
+		"url_site"	=> "text DEFAULT '' NOT NULL",
+		"statut"	=> "varchar(8) DEFAULT '0' NOT NULL",
+		"ip"	=> "varchar(40) DEFAULT '' NOT NULL",
+		"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_auteur"	=> "id_auteur",
+		"KEY id_parent"	=> "id_parent",
+		"KEY id_thread"	=> "id_thread",
+		"KEY optimal" => "statut,id_parent,id_article,date_heure,id_breve,id_syndic,id_rubrique");
+
+$spip_forum_join = array(
+		"id_forum"=>"id_forum",
+		"id_parent"=>"id_parent",
+		"id_article"=>"id_article",
+		"id_breve"=>"id_breve",
+		"id_message"=>"id_message",
+		"id_syndic"=>"id_syndic",
+		"id_rubrique"=>"id_rubrique");
+
+$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 DEFAULT '' NOT NULL",
+		"ad_email"	=> "text DEFAULT '' NOT NULL",
+		"nom_site"	=> "text DEFAULT '' NOT NULL",
+		"url_site"	=> "text DEFAULT '' NOT NULL",
+		"message"	=> "mediumtext DEFAULT '' NOT NULL",
+		"statut"	=> "varchar(10) DEFAULT '0' NOT NULL",
+		"maj"	=> "TIMESTAMP");
+
+$spip_signatures_key = array(
+		"PRIMARY KEY"	=> "id_signature",
+		"KEY id_article"	=> "id_article",
+		"KEY statut" => "statut");
+$spip_signatures_join = array(
+		"id_signature"=>"id_signature",
+		"id_article"=>"id_article");
+
+/// 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, 'join' => &$spip_articles_join);
+$tables_principales['spip_auteurs']  =
+	array('field' => &$spip_auteurs, 'key' => &$spip_auteurs_key,'join' => &$spip_auteurs_join);
+$tables_principales['spip_breves']   =
+	array('field' => &$spip_breves, 'key' => &$spip_breves_key,'join' => &$spip_breves_join);
+$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, 'join' => &$spip_documents_join);
+$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, 'join' => &$spip_syndic_join);
+$tables_principales['spip_syndic_articles']	=
+	array('field' => &$spip_syndic_articles, 'key' => &$spip_syndic_articles_key, 'join' => &$spip_syndic_articles_join);
+$tables_principales['spip_forum'] =
+	array('field' => &$spip_forum,	'key' => &$spip_forum_key, 'join' => &$spip_forum_join);
+$tables_principales['spip_signatures'] =
+	array('field' => &$spip_signatures, 'key' => &$spip_signatures_key, 'join' => &$spip_signatures_join);
+	
+	$tables_principales = pipeline('declarer_tables_principales',$tables_principales);
+}
+
+global $tables_principales;
+base_serial($tables_principales);
+
+?>