Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
3 registered (Tomcruise11, Peter, driv), 35 Guests and 14 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 11/01/06
Posts: 181
Top Posters (30 Days)
Ruben 49
Gizmo 24
DennyP 23
Dunny 17
SteveS 14
AllenAyres 12
dbremer 10
drkknght00 9
SD 9
capnbob 7
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Topic Options
#132203 - 05/14/99 11:47 AM Changing table names
Anonymous
Unregistered

What I'd really like to see is common practice among MySQL-using programs is an identifying tag on each tablename- for example, wwwthread's users table would be wwwt_users, and the Messages table wwwt_Messages.

Or- and this would be even better- have the option to SET the common header in W3TVars.pm, and have that header automatically prepended to every table created or used by WWWThreads.

Why? Some of us only have one database in which to work, and you'd be amazed at how many different programs create the users table- all with different fields, of course.

Is this possible? Please say yes- otherwise I have to do the old search and replace and hope I don't bork anything too badly.

{bump} Scream- just want to get your thoughts on it? I think it could be done simply by abstracting the table names with variables, and for the people who don't want to be broke by upgrading, the defaults of those variables would be the same as the existing table names.. got me? [Smile]
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#132204 - 05/15/99 03:00 AM Re: Changing table names
Anonymous
Unregistered

That's a fabulous suggestion.
Top
#132205 - 05/15/99 03:28 AM Re: Changing table names
Anonymous
Unregistered

Yes... This will also avoid the potential problem of using a table name that happens to be
a reserved word when you want to switch to a different database server.
Top



Moderator:  AllenAyres, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Island Permissions
by ThreadsUser
Yesterday at 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Custom forum permissions
by ntdoc
05/18/12 02:07 PM
Running ads
by Jeffdag
05/17/12 01:47 PM
Forum Stats
10485 Members
36 Forums
33834 Topics
181678 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image