[Sommaire] [Imprimer]

   1  <?php
   2  // added compression 
   3  // added simple archiving
   4  // added faster visitors detection using md5
   5  // idem for page detection
   6  
   7  $allQueries = array(
   8  "ALTER TABLE ".T_ARCHIVES." ADD `nb_uniq_vis_returning` INT NOT NULL",
   9  "ALTER TABLE ".T_ARCHIVES." ADD `compressed` TINYINT( 1 ) UNSIGNED DEFAULT '0' NOT NULL"  ,
  10  "ALTER TABLE ".T_ARCHIVES." ADD `simple` TINYINT( 1 ) UNSIGNED DEFAULT '0' NOT NULL"  ,
  11  "ALTER TABLE ".T_VISIT." ADD `md5config` CHAR( 32 ) NOT NULL",
  12  "CREATE TABLE ".T_PAGE_MD5URL." (
  13    `idpage_md5url` int(10) unsigned NOT NULL auto_increment,
  14    `idpage` int(10) unsigned NOT NULL default '0',
  15    `md5url` char(32) default NULL,
  16    `idpage_url` int(11) unsigned NOT NULL default '0',
  17    PRIMARY KEY  (`idpage_md5url`),
  18    KEY `idpage` (`idpage`),
  19    KEY `url` (`md5url`),
  20    KEY `idpage_url` (`idpage_url`)
  21  )"
  22  
  23  
  24  );
  25  
  26  
  27  foreach($allQueries as $query)
  28  {
  29      query($query);
  30  }    
  31  ?>