From 2101f6c454d670a93ee445f84bfe839aa21bf049 Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Thu, 11 Mar 2004 20:33:59 +0000 Subject: - Rewrote the profile module: + Added a 'created' field to the users table and renamed the 'timestamp' fied to 'changed' (cfr. node table). Update.php will try to determine a 'created' timestamp for existing users. + The profile module no longer uses serialized data but has its own set of tables. Known existing profile data is migrated by these new tables. TODO: migrate the birthday field. + The profile fields can be grouped, and within each group, profile fields can be sorted using weights. + The profile pages can be themed. + The profiles can be browsed based on certain properties/settings. + Change the _user hook: (i) 'private_view' and 'public_view' are merged into 'view' as there are no private fields and (ii) 'edit_form' has been renamed to 'edit'. + Avatar handling has been refactored and is now part of the user module. The users table has a dedicted 'picture' field. + Simplified the way themes should use display/visualize pictures or avatars. + Made it possible for administrators to replace or delete avatars. + ... I hope this make for a good base to build on collectively. --- database/database.pgsql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'database/database.pgsql') diff --git a/database/database.pgsql b/database/database.pgsql index 12975aa29..213f71a93 100644 --- a/database/database.pgsql +++ b/database/database.pgsql @@ -511,10 +511,12 @@ CREATE TABLE users ( threshold smallint default '0', theme varchar(255) NOT NULL default '', signature varchar(255) NOT NULL default '', - timestamp integer NOT NULL default '0', + created integer NOT NULL default '0', + changed integer NOT NULL default '0', status smallint NOT NULL default '0', timezone varchar(8) default NULL, language char(2) NOT NULL default '', + picture varchar(255) NOT NULL DEFAULT '', init varchar(64) default '', data text default '', rid integer NOT NULL default '0', -- cgit v1.2.3