Re: [phpBT-dev] db structure

[Javier S. <js...@si...>]

I think it's a good thing to have the abilty to tune each table name ;-)
Ben Curtis wrote:

>As promised, I've rolled it around in my head a bit, and I think I would like to have a constant for the prefix and a constant for each table name.  This would allow for a prefix or not, and would allow people who prefer StudlyCaps table names to have them.  And since we would be editing every query for the prefix constant anyway, we might as well use table name constants.
>
>Thoughts?
>
>On Tue, Aug 28, 2001 at 01:45:40PM -0700, Ben Curtis wrote:
>
>>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!
>>
>>_______________________________________________
>>phpbt-dev mailing list
>>php...@li...
>>http://lists.sourceforge.net/lists/listinfo/phpbt-dev
>>
>
>_______________________________________________
>phpbt-dev mailing list
>php...@li...
>http://lists.sourceforge.net/lists/listinfo/phpbt-dev
>