diff options
| author | Dries Buytaert <dries@buytaert.net> | 2004-03-11 20:33:59 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2004-03-11 20:33:59 +0000 |
| commit | 2101f6c454d670a93ee445f84bfe839aa21bf049 (patch) | |
| tree | af44af9438d1346ef674d340813323fba134d31a /database/database.pgsql | |
| parent | f10cca1182c1204eafd679e02a3b231f8df3c21b (diff) | |
| download | brdo-2101f6c454d670a93ee445f84bfe839aa21bf049.tar.gz brdo-2101f6c454d670a93ee445f84bfe839aa21bf049.tar.bz2 | |
- 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.
Diffstat (limited to 'database/database.pgsql')
| -rw-r--r-- | database/database.pgsql | 4 |
1 files changed, 3 insertions, 1 deletions
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', |