3 /***************************************************************************\
4 * SPIP, Systeme de publication pour l'internet *
6 * Copyright (c) 2001-2019 *
7 * Arnaud Martin, Antoine Pitrou, Philippe Riviere, Emmanuel Saint-James *
9 * Ce programme est un logiciel libre distribue sous licence GNU/GPL. *
10 * Pour plus de details voir le fichier COPYING.txt ou l'aide en ligne. *
11 \***************************************************************************/
14 * Déclarations relatives à la base de données
16 * @plugin Statistiques pour SPIP
18 * @package SPIP\Stats\Pipelines
21 if (!defined("_ECRIRE_INC_VERSION")) {
26 * Déclarer les tables de statistiques
28 * Déclare les tables :
30 * - spip_visites_articles
32 * - spip_referers_articles
34 * @pipeline declarer_tables_auxiliaires
35 * @param array $tables_auxiliaires
36 * Description des tables auxiliaires
38 * Description complétée des tables auxiliaires
40 function stats_declarer_tables_auxiliaires($tables_auxiliaires) {
42 $spip_visites = array(
43 "date" => "DATE NOT NULL",
44 "visites" => "int UNSIGNED DEFAULT '0' NOT NULL",
48 $spip_visites_key = array(
49 "PRIMARY KEY" => "date"
52 $spip_visites_articles = array(
53 "date" => "DATE NOT NULL",
54 "id_article" => "int UNSIGNED NOT NULL",
55 "visites" => "int UNSIGNED DEFAULT '0' NOT NULL",
59 $spip_visites_articles_key = array(
60 "PRIMARY KEY" => "date, id_article"
64 $spip_referers = array(
65 "referer_md5" => "bigint UNSIGNED NOT NULL",
66 "date" => "DATE NOT NULL",
67 "referer" => "VARCHAR (255)",
68 "visites" => "int UNSIGNED NOT NULL",
69 "visites_jour" => "int UNSIGNED NOT NULL",
70 "visites_veille" => "int UNSIGNED NOT NULL",
74 $spip_referers_key = array(
75 "PRIMARY KEY" => "referer_md5"
78 $spip_referers_articles = array(
79 "id_article" => "int UNSIGNED NOT NULL",
80 "referer_md5" => "bigint UNSIGNED NOT NULL",
81 "referer" => "VARCHAR (255) DEFAULT '' NOT NULL",
82 "visites" => "int UNSIGNED NOT NULL",
86 $spip_referers_articles_key = array(
87 "PRIMARY KEY" => "id_article, referer_md5",
88 "KEY referer_md5" => "referer_md5"
91 $tables_auxiliaires['spip_visites'] = array(
92 'field' => &$spip_visites,
93 'key' => &$spip_visites_key
95 $tables_auxiliaires['spip_visites_articles'] = array(
96 'field' => &$spip_visites_articles,
97 'key' => &$spip_visites_articles_key
99 $tables_auxiliaires['spip_referers'] = array(
100 'field' => &$spip_referers,
101 'key' => &$spip_referers_key
103 $tables_auxiliaires['spip_referers_articles'] = array(
104 'field' => &$spip_referers_articles,
105 'key' => &$spip_referers_articles_key
108 return $tables_auxiliaires;