Database Tables

Mantis Manual

Database Tables
Last Modified: December 12, 2004 09:12AM

(Any)

Description

Mantis enables users to configure a table prefix for all its tables. This is useful to be able to have multiple Mantis installation in the same database. The advantage of that is for users who are limited by their ISP to have one database.

$g_db_table_prefix

Specifies the prefix to be use for all table names. The default value is 'mantis'. If you override the default prefix, make sure to update doc/db_generate.sql file before generating your database. The other option is to import db_generate.sql as is, then rename the tables to match the new prefix.

The table name for each of the tables is stored in a variable which is calculated based on this configuration option. If you change the prefix you have to make sure these variables are re-calculated (by adding these calculation statements to config_inc.php after assigning the new prefix). An example of these variables is: $g_mantis_bug_file_table

The prefix is used to help make sure table names are unique. This is useful for users who are limited to one database.

User Contributed Notes
Database Tables

There are no user contributed notes for this page.

Last updated: Sun, 29 Jan 2012 - 6:57:32