| 831 |
florian |
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 |
?>
|