www/plugins-dist/statistiques/base/stats.php

   1 <?php
   2
   3 /***************************************************************************\
   4  *  SPIP, Systeme de publication pour l'internet                           *
   5  *                                                                         *
   6  *  Copyright (c) 2001-2016                                                *
   7  *  Arnaud Martin, Antoine Pitrou, Philippe Riviere, Emmanuel Saint-James  *
   8  *                                                                         *
   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 \***************************************************************************/
  12
  13 if (!defined("_ECRIRE_INC_VERSION")) return;
  14
  15 function stats_declarer_tables_auxiliaires($tables_auxiliaires){
  16
  17         $spip_visites = array(
  18                         "date"  => "DATE NOT NULL",
  19                         "visites"       => "int UNSIGNED DEFAULT '0' NOT NULL",
  20                         "maj"   => "TIMESTAMP");
  21
  22         $spip_visites_key = array(
  23                         "PRIMARY KEY"   => "date");
  24
  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");
  30
  31         $spip_visites_articles_key = array(
  32                         "PRIMARY KEY"   => "date, id_article");
  33
  34
  35
  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");
  44
  45         $spip_referers_key = array(
  46                         "PRIMARY KEY"   => "referer_md5");
  47
  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");
  54
  55         $spip_referers_articles_key = array(
  56                         "PRIMARY KEY"   => "id_article, referer_md5",
  57                         "KEY referer_md5"       => "referer_md5");
  58
  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);
  71
  72         return $tables_auxiliaires;
  73 }
  74
  75 ?>