Support database table prefix




17 years ago
3 years ago


(Reporter: simona, Unassigned)





17 years ago
In some scenarios (e.g. shared webserver environments such as at 
only a limited number of databases are available. It would be good if the table 
names used by Bugzilla were user defineable at installation (perhaps a user set 
prefix to the standard table names) so that several bugzilla installations 
could share the same database e.g. one installation has a prefix live_ on all 
the table names and another uses test_  Or perhaps productgroup1_ and 
productgroup2_ depending on user requirements. In this way several bugzilla 
installs could share a single database without any clashes over table names.
Priority: -- → P4
Target Milestone: --- → Future
Severity: normal → enhancement
I agree. We only have one database available on our provider's system. This
database is used by other programs too.

Therefore the *default* table names should be:
instead of:

At the very least it should be possible to add a custom prefix in localconfig.
There's no way this will happen if it requires us to complicate our queries by
adding prefixes to each of them.  How it might happen, is if you can
transparently use a substitution regex to add the prefix, in SendSQL, or
whatever we're using nowadays.
It could be done by overriding $dbh->prepare, but it would be nearly impossible
to get right.
OS: FreeBSD → All
Priority: P4 → P5
Hardware: PC → All


14 years ago
Assignee: zach → installation
QA Contact: mattyt-bugzilla → default-qa

Comment 4

13 years ago
*** Bug 343426 has been marked as a duplicate of this bug. ***


13 years ago
Assignee: installation → database
Component: Installation & Upgrading → Database
Summary: RFE: The table names used by Bugzilla could be user defineable → Support database table prefix
Version: 2.14 → 2.23
Target Milestone: Future → ---

Comment 5

12 years ago
Too bad MySQL doesn't support ANSI schemas (as I recall, in 5.0 Create Schema became a synonym for Create Database).

Oracle and MSSQL make it easy, because you can just create a different schema on your database, and set that schema as the default for a given user.  That means you could transparently run multiple Bugzilla instances, each in their own schema (assuming you used different users for each instance.)

I think Postgres works that way as well.  Maybe that should be a default installation step, that when you create the database, users not using MySQL should create a schema and set the database user account to default to that schema?

Comment 6

11 years ago
Max, any interest in implementing this RFE? Else I would suggest WONTFIX.
If at some point in the future we switch to an ORM, it might be possible, so we can keep it open but P5. It's never going to happen as long as Bugzilla is full of raw SQL.

Comment 8

3 years ago
I don't think this will ever happen -> wontfix.
Last Resolved: 3 years ago
Resolution: --- → WONTFIX
You need to log in before you can comment on or make changes to this bug.