We are moving to Git Issues for bug tracking in future releases. During transition, content will be in both tools. If you'd like to file a new bug, please create an issue.

Bug 2287 - Add support for table name prefixes
Add support for table name prefixes
Status: NEW
Product: OJS
Classification: Unclassified
Component: General
3.x
PC Linux
: P2 normal
Assigned To: PKP Support
Depends on:
Blocks: 1728
  Show dependency treegraph
 
Reported: 2006-06-29 09:55 PDT by Alec Smecher
Modified: 2013-05-29 15:00 PDT (History)
1 user (show)

See Also:
Version Reported In:
Also Affects:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Alec Smecher 2006-06-29 09:55:05 PDT
In case of collisions and to support multiple OJS 2.x installations in the same
database, add support for table name prefixes (e.g. my_users instead of users).
In addition to modifying every query in OJS, the schema tools need to be
modified to support this option. ADODB has a $schema->SetPrefix function that
should help with this.
Comment 1 Alec Smecher 2007-07-05 14:58:12 PDT
Deferring for now. We haven't had much call for this.
Comment 2 Jacob Andersson 2012-06-26 09:02:58 PDT
I'd like to add support for this suggestion. My host only allows me to use one database, and I use several different CMSs, which is very difficult unless table name prefixes are used.
Comment 3 Alec Smecher 2012-06-26 09:44:24 PDT
Jacob, there are a lot of reasons why mixing several applications in the same database is a bad idea. We have had very few calls for table prefix support, and it would represent quite a bit of work. For these reasons it's a low priority for us. If this is a showstopper I would suggest finding a host that allows multiple databases in one account; these are very common and inexpensive.