* Pour plus de details voir le fichier COPYING.txt ou l'aide en ligne. *
\***************************************************************************/
-if (!defined("_ECRIRE_INC_VERSION")) return;
+/**
+ * Déclarations relatives à la base de données
+ *
+ * @plugin Statistiques pour SPIP
+ * @license GNU/GPL
+ * @package SPIP\Stats\Pipelines
+ **/
+
+if (!defined("_ECRIRE_INC_VERSION")) {
+ return;
+}
-function stats_declarer_tables_auxiliaires($tables_auxiliaires){
+/**
+ * Déclarer les tables de statistiques
+ *
+ * Déclare les tables :
+ * - spip_visites
+ * - spip_visites_articles
+ * - spip_referers
+ * - spip_referers_articles
+ *
+ * @pipeline declarer_tables_auxiliaires
+ * @param array $tables_auxiliaires
+ * Description des tables auxiliaires
+ * @return array
+ * Description complétée des tables auxiliaires
+ */
+function stats_declarer_tables_auxiliaires($tables_auxiliaires) {
$spip_visites = array(
- "date" => "DATE NOT NULL",
- "visites" => "int UNSIGNED DEFAULT '0' NOT NULL",
- "maj" => "TIMESTAMP");
+ "date" => "DATE NOT NULL",
+ "visites" => "int UNSIGNED DEFAULT '0' NOT NULL",
+ "maj" => "TIMESTAMP"
+ );
$spip_visites_key = array(
- "PRIMARY KEY" => "date");
+ "PRIMARY KEY" => "date"
+ );
$spip_visites_articles = array(
- "date" => "DATE NOT NULL",
- "id_article" => "int UNSIGNED NOT NULL",
- "visites" => "int UNSIGNED DEFAULT '0' NOT NULL",
- "maj" => "TIMESTAMP");
+ "date" => "DATE NOT NULL",
+ "id_article" => "int UNSIGNED NOT NULL",
+ "visites" => "int UNSIGNED DEFAULT '0' NOT NULL",
+ "maj" => "TIMESTAMP"
+ );
$spip_visites_articles_key = array(
- "PRIMARY KEY" => "date, id_article");
-
+ "PRIMARY KEY" => "date, id_article"
+ );
$spip_referers = array(
- "referer_md5" => "bigint UNSIGNED NOT NULL",
- "date" => "DATE NOT NULL",
- "referer" => "VARCHAR (255)",
- "visites" => "int UNSIGNED NOT NULL",
- "visites_jour" => "int UNSIGNED NOT NULL",
- "visites_veille"=> "int UNSIGNED NOT NULL",
- "maj" => "TIMESTAMP");
+ "referer_md5" => "bigint UNSIGNED NOT NULL",
+ "date" => "DATE NOT NULL",
+ "referer" => "VARCHAR (255)",
+ "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");
+ "PRIMARY KEY" => "referer_md5"
+ );
$spip_referers_articles = array(
- "id_article" => "int UNSIGNED NOT NULL",
- "referer_md5" => "bigint UNSIGNED NOT NULL",
- "referer" => "VARCHAR (255) DEFAULT '' NOT NULL",
- "visites" => "int UNSIGNED NOT NULL",
- "maj" => "TIMESTAMP");
+ "id_article" => "int UNSIGNED NOT NULL",
+ "referer_md5" => "bigint UNSIGNED NOT NULL",
+ "referer" => "VARCHAR (255) DEFAULT '' 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");
+ "PRIMARY KEY" => "id_article, referer_md5",
+ "KEY referer_md5" => "referer_md5"
+ );
$tables_auxiliaires['spip_visites'] = array(
'field' => &$spip_visites,
- 'key' => &$spip_visites_key);
+ 'key' => &$spip_visites_key
+ );
$tables_auxiliaires['spip_visites_articles'] = array(
'field' => &$spip_visites_articles,
- 'key' => &$spip_visites_articles_key);
+ 'key' => &$spip_visites_articles_key
+ );
$tables_auxiliaires['spip_referers'] = array(
'field' => &$spip_referers,
- 'key' => &$spip_referers_key);
+ 'key' => &$spip_referers_key
+ );
$tables_auxiliaires['spip_referers_articles'] = array(
'field' => &$spip_referers_articles,
- 'key' => &$spip_referers_articles_key);
+ 'key' => &$spip_referers_articles_key
+ );
return $tables_auxiliaires;
}
-
-?>