ProcessMaker can manage numerous workspaces at a time. Each workspace has 3 MySQL databases in version 2.5.X and earlier:
This database contains the information required by the Process Engine, including information about processes, cases, users, PM Tables, etc.
For version 2.0 and earlier see the Entity-Relationship diagram of this database.
For version 2.0 and later see the Entity-Relationship Diagram.
This database contains the information about users to maintain a Role-Based Access Control (RBAC) system in ProcessMaker.
See the Entity-Relationship diagram of this database.
This database is designed to allow external applications to access data from ProcessMaker cases. Each Report Table creates a separate table in this database, which external databases can query. If ProcessMaker was installed with the Automatic Windows Installer before version 1.6-4260, then this database is named rp_<workspace>
Single database in version 2.8 and later
In version 2.8 and later, new installations of ProcessMaker will use only the wf_<workspace> database for each workspace, in order to facilitate the use of ProcessMaker in hosted servers which limit the number of databases. If upgraded from a previous version, ProcessMaker 2.8 and later will continue to use 3 databases.
The tables which were previously located in the rb_<workspace> database have been moved to the wf_<workspace> database and the prefix RBAC_<workspace> has been added to their table names:
- RBAC_AUTHENTICATION_SOURCE, RBAC_PERMISSIONS, RBAC_ROLES, RBAC_ROLES_PERMISSIONS, RBAC_SYSTEMS, RBAC_USERS, RBAC_USERS_ROLES
Likewise, the Report Tables which were previously located in the rp_<workspace> database have been moved to the wf_<workspace> database and these tables have the prefix PMT_ in their names.
The default workspace created in ProcessMaker is called workflow, so its databases are named wf_workflow, rb_workflow and rp_workflow. If doing a manual install of ProcessMaker, the setup screen provides an option to rename these databases. See Consulting the ProcessMaker databases for more information about how to access these databases with MySQL and phpMyAdmin.
The files for the MySQL databases are generally stored in the following locations:
The location depends upon your distribution, but it is generally:
If installed with the ProcessMaker Windows Installer, the MySQL files are generally stored at:
- C:\Program Files\ProcessMaker\mysql\data\rb_workflow\
- C:\Program Files\ProcessMaker\mysql\data\rp_workflow\
- C:\Program Files\ProcessMaker\mysql\data\wf_workflow\