3 /***************************************************************************\
4 * SPIP, Systeme de publication pour l'internet *
6 * Copyright (c) 2001-2014 *
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 \***************************************************************************/
13 if (!defined("_ECRIRE_INC_VERSION")) return;
15 function stats_declarer_tables_auxiliaires($tables_auxiliaires){
17 $spip_visites = array(
18 "date" => "DATE NOT NULL",
19 "visites" => "int UNSIGNED DEFAULT '0' NOT NULL",
20 "maj" => "TIMESTAMP");
22 $spip_visites_key = array(
23 "PRIMARY KEY" => "date");
25 $spip_visites_articles = array(
26 "date" => "DATE NOT NULL",
27 "id_article" => "int UNSIGNED NOT NULL",
28 "visites" => "int UNSIGNED DEFAULT '0' NOT NULL",
29 "maj" => "TIMESTAMP");
31 $spip_visites_articles_key = array(
32 "PRIMARY KEY" => "date, id_article");
36 $spip_referers = array(
37 "referer_md5" => "bigint UNSIGNED NOT NULL",
38 "date" => "DATE NOT NULL",
39 "referer" => "VARCHAR (255)",
40 "visites" => "int UNSIGNED NOT NULL",
41 "visites_jour" => "int UNSIGNED NOT NULL",
42 "visites_veille"=> "int UNSIGNED NOT NULL",
43 "maj" => "TIMESTAMP");
45 $spip_referers_key = array(
46 "PRIMARY KEY" => "referer_md5");
48 $spip_referers_articles = array(
49 "id_article" => "int UNSIGNED NOT NULL",
50 "referer_md5" => "bigint UNSIGNED NOT NULL",
51 "referer" => "VARCHAR (255) DEFAULT '' NOT NULL",
52 "visites" => "int UNSIGNED NOT NULL",
53 "maj" => "TIMESTAMP");
55 $spip_referers_articles_key = array(
56 "PRIMARY KEY" => "id_article, referer_md5",
57 "KEY referer_md5" => "referer_md5");
59 $tables_auxiliaires['spip_visites'] = array(
60 'field' => &$spip_visites,
61 'key' => &$spip_visites_key);
62 $tables_auxiliaires['spip_visites_articles'] = array(
63 'field' => &$spip_visites_articles,
64 'key' => &$spip_visites_articles_key);
65 $tables_auxiliaires['spip_referers'] = array(
66 'field' => &$spip_referers,
67 'key' => &$spip_referers_key);
68 $tables_auxiliaires['spip_referers_articles'] = array(
69 'field' => &$spip_referers_articles,
70 'key' => &$spip_referers_articles_key);
72 return $tables_auxiliaires;