Re: [phpBT-dev] db structure

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

I was thinking of this the other night.  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." ...  If you'd like to do this I can add you to the project as a developer.

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.

On Tue, Aug 28, 2001 at 07:55:08PM +0200, Patrick Mairif wrote:
> On Tue, 28 Aug 2001, Ben Curtis wrote:
> 
> > Yup, createdb.sql hasn't been updated for the new db structure yet.
> > But you can use dbchanges.sql and perms.sql to move to the new table
> > structure.  createdb.sql will be updated before the release is made -- I
> > haven't done it yet because the database changes aren't final yet. :)
> 
> perhaps there is space for additional suggestions, if the changes aren't
> complete:
> 
> My ISP let me use only one mysql database, so phpBT hast to share the
> same db with my other projects. I'm sure more people are in this
> situation, so tablenames starting with a prefix like 'BT_' or 'phpBT_'
> would be great.
> Is this possible? I could do the changes.
> 
> greetz!
> 
> 
> _______________________________________________
> phpbt-dev mailing list
> php...@li...
> http://lists.sourceforge.net/lists/listinfo/phpbt-dev