Product SiteDocumentation Site

5.2.2. Database table naming settings

MantisBT allows administrators to configure a prefix and a suffix for its tables. This enables multiple MantisBT installation in the same database or schema.

Warning

Use of long strings for these configuration options may cause issues on RDBMS restricting the size of its identifiers, such as Oracle (which imposed a maximum size of 30 characters until version 12.1; starting with 12cR2 this limit has been increased to 128).
To avoid this limitation, it is recommended that
  • the prefix is set to blank or kept as short as possible (e.g. m).
  • the suffix is set to blank.
  • the plugin prefix is kept as short as possible (e.g. plg).
$g_db_table_prefix
Specifies the prefix to be used for all table names. The default value is mantis.
The given string is added with an underscore before the base table name, e.g. for the bug table, the actual table name with the default prefix would be mantis_bug.
$g_db_table_suffix
Specifies the suffix to be appended to all table names. The default value is table.
The given string is added with an underscore after the base table name, e.g. for the bug table, the actual table name with the default suffix would be bug_table.
$g_db_table_plugin_prefix
Specifies the prefix to be used to differentiate tables belonging to a plugin's schema from MantisBT's own base tables. The default value is plugin.
The given string is inserted with an underscore between the table prefix and the base table name, and the plugin basename is added after that, e.g. for a table named foo in the Example plugin, with default values for prefixes and suffix the physical table name would be mantis_plugin_Example_foo_table.

Warning

It is strongly recommended not to use an empty string here, as this could lead to problems, e.g. conflicts if a plugin's basename happens to match one of MantisBT's base tables.
$g_dsn
Adodb Data Source Name This is an EXPERIMENTAL field. If the above database settings, do not provide enough flexibility, it is possible to specify a dsn for the database connection. NOTE: the installer does not yet fully support the use of dsn's