Section 2.3 Database Tables

Data on the registered modules is recorded in the Plesk database. On the basis of these records the list of modules available for management is created.

Besides the records about the registered modules, the database also contains tables for custom settings for each module. These tables should have the following appearance: module_<module_name>_* (for example table can have name: module_fileserver_users).

The table in the Plesk database, which serves for storing information on the installed modules looks as follows:

CREATE TABLE Modules (
id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY -- ID, autogenerated
, name VARCHAR(255) BINARY NOT NULL -- module name
, packname VARCHAR(255) BINARY NOT NULL -- package name (probably the same as name)
, display_name VARCHAR(255) BINARY NOT NULL -- is display module name
, version VARCHAR(30) BINARY NOT NULL -- module version
, release INT UNSIGNED NOT NULL -- package release
, description VARCHAR(255) -- description of this module
, icon VARCHAR(255) BINARY NOT NULL -- icon for module in Control Panel
, UNIQUE(name)
);

See the example of the file with tables for module databases.