[Sommaire] [Imprimer]

   1  <?php
   2  if(!defined("PHORUM_ADMIN")) return;
   3  
   4  // altering the files tables
   5  $upgrade_queries[]="alter table {$PHORUM['user_table']} add `date_added` int(10) unsigned NOT NULL default '0'";
   6  $upgrade_queries[]="alter table {$PHORUM['user_table']} add `date_last_active` int(10) unsigned NOT NULL default '0'";
   7  $upgrade_queries[]="alter table {$PHORUM['user_table']} add `hide_activity` tinyint(1) NOT NULL default '0'";
   8  
   9  $upgrade_queries[]="alter table {$PHORUM['user_table']} add KEY `activity` (`date_last_active`,`hide_activity`)";
  10  $upgrade_queries[]="alter table {$PHORUM['user_table']} add KEY `date_added` (`date_added`)";
  11   
  12  $upgrade_queries[]="update {$PHORUM['user_table']} set date_last_active=UNIX_TIMESTAMP(NOW()), date_added=UNIX_TIMESTAMP(NOW())";
  13  
  14  ?>