[phpBT-dev] Postgres SQL problems

[Ben C. <php...@be...>]

Javier, I'm going to repost your email to me here as now there are three people watching this list. :)

--- Javier wrote ---
The actual database schema have som conflicts whith SQL key words ... 
have a look at  
http://www.fr.postgresql.org/devel-corner/docs/postgres/sql-keywords-appendix.html#KEYWORDS-TABLE

there is some words like 'user' which doesn't work without ""  :-(
A prefer to let you make the choice of the new table names ...

-------

Well, I guess this is as good an impetus as any for me to get off my butt and do the user table correctly.  This will probably push 0.3.0 back a week but I think it's worth it.  I don't know exactly how it's going to work yet, but here's what I'm thinking so far.  I'm open to suggestions on it.  For more background on the issues with user info tables you can see the phplib-users list at sourceforge and the phplib list at netuse.de.  You don't really need that background, though, to catch up with what I want to do.

Javier, you should like this, as it will also address the desire you had to use a login name that was not an email address. :)  So here's the deal:  the user table will have to change names (I'm not sure to what yet) so we can use it unquoted in postgres.  At the same time I will add a user_name field that will be used for logging in.  Admins will have the option of just using the email address for login, in which case the email address will be in both the user_name field and the email field.  I'll also do some thinking on how I want to link users to projects, so this will help your desire, Michael to get the group restrictions going.

So, the changes aren't really that complicated after all, but I want to make sure I have plenty of time to think it out so that it will be flexible enough for our needs.  Comments?