Please note: This page is under construction and has not been finished yet.
- Do not modify the core database structure
Use your own tables (for example by creating a plugin) if you want to work with additional data in the database.
- Do not (ab)use database tables and fields for other purposes
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
There are several ways the database prefix is used:
- 1.Recommended: It is strongly recommend to make use of the database methods. Using these methods, the database table prefix is processed automatically.
- 2.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.
- 3.In rare cases, you may reference the
MPREFIXconstant. Its use is deprecated and not encouraged.
TODO: Finish table below.
The following table provides an overview of all database tables in a clean e107 installation, with their respective purposes.
Table for generic purposes. Generally used to store temporary date. Currently also used by welcome message. Developers are discouraged to use this table!