Re: [PHPLIB] Extending user_auth table or creating a new table From: Alexander Aulbach (ssilk <email protected>)
Date: 02/28/00

On Tue, 29 Feb 2000, Howard Ha wrote:

}I've asked this once before, and was told that some of you extend the
}auth_user table, while others add a new table for user info.
}
}If you were to create an extensive user profile, which would be your
}preferred route? Use the auth_user table and extend it with the extra
}columns, or create an entirely new table and put info there?

An extensive way of a user profile would be a adress database like I find
it on my Psion mx pro.

The adress profile constist out of 20 or more known entries.
Example:

Title *
Surname
Second Surname *
Name
Suffix *
Tel Mobil
Tel Private
Pager private *
E-Mail private
Street private
ZIP private
Town private
State private
Country private
More Adress private *

Firm
Position
Tel Job
Fax Job
Pager Job *
E-Mail Job
Webpage
Street Job
ZIP Job
Town Job
State Job
Country Job
More Adress Job *

Birthday *
Notes

* means, that this item is not displayed by default.

Every item can be added as often as need. It's not problem to add two
firm-Items, or two telephone items, if you need it. This can be very
practical, cause you can make a very well-groomed adress database.

The data strukture for such a database I would create like the following:

CREATE TABLE auth_user (
  p_user_id varchar(32) DEFAULT '' NOT NULL,
  p_short_id int NOT NULL,
  p_username varchar(32) DEFAULT '' NOT NULL,
  p_pwenc varchar(16) DEFAULT '' NOT NULL,
  p_password varchar(32) DEFAULT '' NOT NULL,
  p_perms varchar(255),
  PRIMARY KEY (p_user_id),
  UNIQUE k_username (p_username),
  UNIQUE k_short_id (p_short_id)
);

CREATE TABLE adress (
  a_p_id int NOT NULL references auth_user (p_short_id),
  a_item varchar(64),
  a_data text
);

This is of course the most simplest structure.

And of course it is not very easy to write an editor, that can handle all
this data... 

-- 
 SSilk - Alexander Aulbach - Herbipolis/Frankonia Minoris - (0931)22032

-
PHP3 Base Library Mailing List. Send messages to <phplib <email protected>>.
To unsubscribe, send "unsubscribe" to <phplib-request <email protected>> in
the body, not the subject, of your message.