CiviCRM Community Forums (archive)

I have a couple of questions about the MySQL database.

1. Why does CiviCRM not follow the Joomla database prefix naming scheme as other components do? (i.e. every Joomla component leads with the same prefix as Joomla files, jos_componentname)

2. Can it be set up to do so? I don't recall any option in the installation to specify anything about the database.

The reasoning is that several multi-site components were created for Joomla 1.6, most of which use Views and creating duplicates of the primary Joomla database tables (but not the installation itself). Every component is available in each additional site and can pull its information from either a standalone database (jos_additionalsite_componentname) or share the main site's tables.  However, because CiviCRM doesn't follow the Joomla structure (it creates its own within the same database), those tables don't get replicated and CiviCRM doesn't work in any of the additional installs.

Another issue is that variables are defined in a settings file (install location, media, etc) instead of in the database. Changing those in the CiviCRM admin section would change it for the entire install, would it not?

Thanks for the reply!