RE: [PHPLIB] Extending user_auth table or creating a new table From: Davor Cengija (davor <email protected>)
Date: 02/29/00

On Mon, 28 Feb 2000, Howard Ha wrote:

>I am sort of wary of using the hash value as the ID number for relating the
>items, because of their size. So I was thinking of using the autoincrement
>values to relate different items in different tables. Does anyone have any
>experience or comments on this?

        I'm doing it all the time, and I didn't have any problems (yet
        :-)

        Actually, I completelly dropped out 32-chars random string
        generation procedure and replaced uid char(32) uid uid int
        auto_increment. No functions are broken, and adding users
        procedure is slightly changed.

        And to answer your previos question, I usually split users
        informations to auth_user and client_info tables. Auth_info
        contains autentification data only (id, username and password)
        and all the rest is in the client_info. I think it should be
        faster, especially on larger systems. Plus you don't have to
        worry about the users' informations when upgrading phplib and
        auth_info table. 

-- 
      v
Davor Cengija
davor <email protected>
===================================
"Please allow 30 days for delivery"

-
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.