Re: [phpBT-dev] New schema

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

On Mon, Aug 27, 2001 at 11:45:13AM +0200, Javier Sixto wrote:
> Ben Curtis wrote:
> 
> >So, I took Kristian's (phplib author) ideas for a new auth schema 
> >(http://www.geocrawler.com/archives/3/195/2001/7/150/6234214/) as a 
> >starting point.  Making the changes in the recent commit _will_ kill your 
> >ability to login to phpbt as a user -- just a warning.  Of course, I'll try 
> >to get the login stuff working tomorrow so it won't be a problem too long.  
> >I just wanted to get the schema into your hands so you can poke at it and 
> >see what ideas come.
> >
> Well, it looks good and very powerfull ! :-)
> Do you thnik this perms/auth modification will delayed reales 0.3.0 ?

No, if we can get the email -> login done this week, it shouldn't.  I still want to put the project/group membership off until 0.4.0.

> 
> >This layout is flexible enough to assign users to groups, perms to groups, 
> >and even perms to users (though at the moment I don't think we have enough 
> >to perms to worry about perms to users).  When new projects are created the 
> >project name should be entered into auth_group.  These groups won't 
> >actually have perms assigned to them, but will be used for checking if 
> >users can work with certain projects.  So I'm thinking of a function like 
> >member_of_group($projectname) would return a boolean or some such (it's too 
> >late for me to be thinking of implementation). :)
> >
> >So, feel free to give me some comments on whether you think this is way to 
> >achieve our goals.  Oh, and Javier, I forgot to add the login_name to 
> >auth_user -- so feel free to do it or I'll do it tomorrow.
> >
> You are so fast ;-)
> Just a notice : why we don't use a unique key for login field ?to avoid 
> any errors ?
> I see you are using $Id: $ :-)  

Yup, the login field should be a unique key -- oversight on my part.