Re: [phplib] Customizing table fields From: Douglas Forrest (dougforrest <email protected>)
Date: 07/02/01

You can use whatever names you want for columns in your customer table,
including column names from the auth_user table.

Changing the names of existing auth_user columns is possible but not
generally advisable. PHPlib functions which use the auth_user table expect
to find and use columns with the existing names and this code would have to
be modified and maintained if you change the column names.

Adding additional columns with your own names to auth_user works fine but
runs the probably small risk that future extensions of the auth_user table
in new phplib versions may include columns with the same names that you have
used, requiring you to modify your code if you want to use the new versions.

The best choice is probably to maintain your own data in the customer table
and link to the corresponding auth_user record. This can be done by
including the auth_user user_id key in the customer column, calling the
column something like "auth_user_id", or else by including the customer
user_id column in the auth_user table using a column name like
"customer_user_id". I do the latter myself.

----- Original Message -----
From: Nino Katic <nkatic <email protected>>
To: <phplib <email protected>>
Sent: Monday, July 02, 2001 7:48 AM
Subject: [phplib] Customizing table fields

> Hi,
>
> Is it possible to use my own names for table columns? I want to use
> auth_user table column fields in my table named customer. I also have
> different table column names. For example in auth_user there is user_id,
> username etc. but i want to use my own. So is this possible and how?
>
> Nino
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: phplib-unsubscribe <email protected>
> For additional commands, e-mail: phplib-help <email protected>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>