Hello,

I have two GT scripts: Links SQL and DBMan SQL;
and the UltraBoard SQL script.

I have created a seperate Database for UltraBoard SQL.

My question(s):
1. Should/can I run both GT scripts from the same Database?

Note: I will be creating/using multiple tables for the DBMan SQL script.

2. Are there any conflicting issues to be aware of?
Any recommendations/insight?

I'm new to databases and hope these questions will be easy for the experienced.

Thanks for any help in advance.


Leo

Hi,

I've run several MySQL based applications from a single database in the past without any problems, and providing each table has a unique name you should be okay.

Someone more experienced may have more to add, but I think that covers it

All the best
Shaun

Yes there is no problem running Links SQL and DBMAN SQL from the same database. Just add a prefix to the Links SQL tables for safety...eg "Links_" - you can do that from the setup script.

You then don't need to alter the DBMAN tables but could add a "DBMAN_" prefix if you wanted.

Paul
Installations:http://wiredon.net/gt/
Support: http://wiredon.net/forum/

Thanks for the help/instructions/guidelines.

I noticed that the UltraBoard and Links SQL installations did allow the instaler to specify a table prefix; and I did specify them.

How can I now, after installation, specify a prefix for the DBMan SQL table(s)?

Will DBMan SQL have this feature included in the next install.cgi?

Thanks,

Leo

Hi,

DBMan SQL does not use a prefix for a number of reasons. The main reason is it's designed to work with existing tables. So if you have an SQL tables called Cars, then it needs to be able to access this table. A prefix would throw everything off. All it's system tables are labled Dbsql_ so it won't interfere with anything.

Cheers,

Alex

--
Gossamer Threads Inc.

Unique column/field names as well...to reduce coding...and confusion when you are programming between the different scripts.

Regards,

Eliot Lee