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

riaanvj@radioretail.co.za 29-Jul-2004 6:22	`#181`
`I have installed mantis configured with Postgresql but a lot of tables are missing in the pgsql.sql file.`

goldie241977@hotmail.com 01-Feb-2006 5:08	`#859`
`Hi, Can u please let me know how do i add different status in system. like resolved, assigned & want to add some more. Please revert.`

andrewwang1@yahoo.com 30-Nov-2006 4:49	`#1310`
`I just download the version 1.0.6 and 1.1.0a1, but after uncompressing it I can not find the db_generate.sql ...`

Last updated: Wed, 20 Aug 2008 - 5:09:20