Database structure
Please note: This page is under construction and has not been finished yet.
Introduction
Best practices
Do not modify the core database structure
Do not (ab)use database tables and fields for other purposes
Database prefix
The default database table prefix is e107_ and can be customized by the user during the installation of e107. The prefix that is used on an installation can always be found in the e107_config.php file.
There are several ways the database prefix is used:
Recommended: It is strongly recommend to make use of the database methods. Using these methods, the database table prefix is processed automatically.
By using the
#sign, one can automatically refer to the database prefix. This is generally used when using the e107::getDB()->gen() method, to manually construct an SQL query.In rare cases, you may reference the
MPREFIXconstant. Its use is deprecated and not encouraged.
Database tables overview
TODO: Finish table below.
The following table provides an overview of all database tables in a clean e107 installation, with their respective purposes.
Last updated