From 39d0fe9a3882f26ff1abe2bca2c28f94b0a8cec0 Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Sat, 7 May 2005 11:39:54 +0000 Subject: - User module improvements: added an 'access' column to the users-table to keep track of the user's last access. In turn, this allowed me to: 1. Optimize the "Who's online" block. On drupal.org, the "Who's online" block requires 32 SQL queries. With this patch, only 2 queries are left (eliminated 30 SQL queries), and one of the two remaining queries became appr. 20 times faster. 2. Correct the "Last access" column in the user administration overview table. The presented data was not accurate, which led to the column being removed. You can now sort users by 'last access'. --- database/database.pgsql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'database/database.pgsql') diff --git a/database/database.pgsql b/database/database.pgsql index 67f7ed631..f4d4b831a 100644 --- a/database/database.pgsql +++ b/database/database.pgsql @@ -687,7 +687,7 @@ CREATE TABLE users ( theme varchar(255) NOT NULL default '', signature varchar(255) NOT NULL default '', created integer NOT NULL default '0', - changed integer NOT NULL default '0', + access integer NOT NULL default '0', login integer NOT NULL default '0', status smallint NOT NULL default '0', timezone varchar(8) default NULL, -- cgit v1.2.3