Re: [phpBT-dev] db structure

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

On Tue, Aug 28, 2001 at 10:35:56PM +0200, Patrick Mairif wrote:
> On Tue, 28 Aug 2001, Ben Curtis wrote:
> > What should happen is that a constant is added to config.php for the
> > table name prefix, like phpbt_.  Then constants need to be added for
> > each table name using the prefix constant.  Then all the queries need to
> > be changed to use the new constants -- instead of "select from auth_user
> > ..." it would be "select from ".USER_TABLE." ...
> 
> Why not one constant for the prefix that is used in all queries?

That's an alternative... let me let it roll around in my head a bit

> 
> The other suggestion from Javier sounds good, too, but I think it is not
> necessary. I think an array is a bit overloaded, isn't it?

Hmm, I didn't see a suggestion from Javier -- either I missed it or he didn't send it to the list. :)

> 
> >  If you'd like to do this I can add you to the project as a developer.
> 
> ok, I would do this, just add me!

You've been added

> 
> > It doesn't have to be right away, but it would also be nice to have this
> > prefix configurable via the configure script and have that script change
> > the db schema file accordingly.
> 
> gonna see, what I can do. :)
> 

Cool!  And, welcome aboard!