Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Re: MySQL Question - Virtual Server

Quote Reply
Re: MySQL Question - Virtual Server In reply to
Yes, they can all go in the existing database. In your config you are asked for what you want the tables to be named (there are four per database). If you want two completely separate tables, then you would just have two config files, each with different table names:

Code:
# The table name to store all your information.
$db_table = 'Items';
# The table name to store your logging information.
$db_table_log = 'Items_log';
# The table name to store your session information.
$db_table_session = 'Items_session';
# The table name to store user information
$db_table_user = 'Items_users';
and say for example your other table is about employees:

Code:
# The table name to store all your information.
$db_table = 'Employee';
# The table name to store your logging information.
$db_table_log = 'Employee_log';
# The table name to store your session information.
$db_table_session = 'Employee_session';
# The table name to store user information
$db_table_user = 'Employee_users';
Now if you wanted to share a common login (so one password would work for both tables), then you would want to make the user and session tables the same thing.

Hope this helps,

Alex

--
Gossamer Threads Inc.
Subject Author Views Date
Thread MySQL Question - Virtual Server Dinky 3748 May 17, 2000, 5:18 PM
Thread Re: MySQL Question - Virtual Server
Alex 3639 May 17, 2000, 9:08 PM
Thread Re: MySQL Question - Virtual Server
Dinky 3620 May 18, 2000, 8:17 AM
Thread Re: MySQL Question - Virtual Server
Alex 3631 May 18, 2000, 10:59 AM
Post Re: MySQL Question - Virtual Server
msmoore 3427 Jul 24, 2001, 11:16 AM