On Tue, Mar 30, 2010 at 01:36:27PM -0700, Tommy Pham wrote:

> Hi,
> I'm just wondering if anyone on this list using some type of
> UID/UUID/GUID in any of the DB?  If so, what DBMS/RDBMS are you using
> and how many rows do you have for the table(s) using it?  What data
> type are you using for that column?

If I understand you correctly, I use a single table, "users". Either
MySQL or PostgreSQL (depending on the application). There is one record
per user, and that record contains a serial/sequential ID, set by the
system, a user ID which is varchar(8), email address which is
varchar(255), username which is varchar(50) and a password which is
varchar(32) and stored encrypted.

There are other related tables I use to record which URLs require
security and which users have access to those URLs.


Paul M. Foster

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to