Overview

ProcessMaker can manage numerous workspaces at a time. Each workspace has one MySQL database for each workspace in order to facilitate the use of ProcessMaker in hosted servers which limit the number of databases.

Note: If upgraded from a previous version, ProcessMaker 2.8 and later will continue to use 3 databases. For more information, please check out 2.0 ProcessMaker Database Model.

wf_<workspace-name>

This database contains all the information required by the Process Engine, including information about processes, cases, users, PM Tables, etc.

Tables with prefix RBAC added to their table names contain the information about users to maintain a Role-Based Access Control (RBAC) system in ProcessMaker.

RBAC_AUTHENTICATION_SOURCE, RBAC_PERMISSIONS, RBAC_ROLES, RBAC_ROLES_PERMISSIONS, RBAC_SYSTEMS, RBAC_USERS, RBAC_USERS_ROLES

The database also includes Report Tables designed to allow external applications to access data from ProcessMaker cases. Report Tables have the prefix PMT_ in their names. Each Report Table creates a separate table in this database, which external databases can query.

Click the images below to see the Entity-Relationship diagram of this database. The diagram is divided in three parts for better understanding.

Database Schema Changes From ProcessMaker 3.0 to 3.1

The following tables describe all the changes that ProcessMaker database schema has suffered since ProcessMaker version 3.0 to 3.1. This changes involve: "New fields added", "Fields Updated", "Default updates" and "Field Type changes". Notice there has not been removal of fields which means that existing records won't get lost when performing an upgrade from ProcessMaker 3.0 to 3.1.

New Tables Created

APP_SEQUENCE NOTIFICATION_QUEUE
EMAIL_EVENT SCRIPT_TASK
GMAIL_RELABELING TIMER_EVENT
NOTIFICATION_DEVICE

Tables Updated

Table Changes
ABE_CONFIGURATION New Fields:
  • `ABE_FORCE_LOGIN` INTEGER default 0,
  • `ABE_MAILSERVER_OR_MAILCURRENT` INTEGER default 0,
  • `ABE_CUSTOM_GRID` MEDIUMTEXT,
Updated Fields:
  • `ABE_SUBJECT_FIELD` VARCHAR(100) default '',
New Keys:
  • KEY `indexAbeProcess`(`PRO_UID`),
  • KEY `indexAbeProcessTask`(`PRO_UID`, `TAS_UID`)
ABE_RESPONSES Removed Keys:
  • SET FOREIGN_KEY_CHECKS = 1;
ADDITIONAL_TABLES New Keys:
  • KEY `indexAdditionalProcess`(`PRO_UID`)
ADDONS_MANAGER New Keys:
  • KEY `indexAddonsType`(`ADDON_TYPE`)
APPLICATION New fields:
  • `APP_TITLE` MEDIUMTEXT NOT NULL,
  • `APP_DESCRIPTION` MEDIUMTEXT,
  • `APP_DRIVE_FOLDER_UID` VARCHAR(32) default '',
  • `APP_ROUTING_DATA` MEDIUMTEXT,
APP_ASSIGN_SELF_SERVICE_VALUE Updated Fields:
  • `GRP_UID` MEDIUMTEXT NOT NULL
APP_CACHE_VIEW New Keys:
  • KEY `indexAppUid`(`APP_UID`),
  • KEY `indexTasUid`(`TAS_UID`),
  • KEY `indexUsrUid`(`USR_UID`),
  • KEY `indexPrevUsrUid`(`PREVIOUS_USR_UID`),
  • KEY `indexProUid`(`PRO_UID`),
  • KEY `taskUid`(`TAS_UID`)
APP_DOCUMENT New Fields:
  • `APP_DOC_DRIVE_DOWNLOAD` MEDIUMTEXT,
  • `SYNC_WITH_DRIVE` VARCHAR(32) default 'UNSYNCHRONIZED' NOT NULL,
  • `SYNC_PERMISSIONS` MEDIUMTEXT
APP_MESSAGE Required removed:
  • `APP_MSG_ERROR` MEDIUMTEXT
BPMN_FLOW Updated Fields:
  • `FLO_CONDITION` VARCHAR(512)
CASE_SCHEDULER New Fields:
  • `SCH_EXECUTION_DATE` DATETIME,
Updated Fields:
  • `SCH_MONTHS` CHAR(27) default '0|0|0|0|0|0|0|0|0|0|0|0' NOT NULL
CONTENT New Keys:
  • KEY `indexUidLang`(`CON_ID`, `CON_LANG`),
  • KEY `indexCatParUidLang`(`CON_CATEGORY`, `CON_PARENT`, `CON_ID`, `CON_LANG`)
DB_SOURCE Updated Fields:
  • `DBS_PASSWORD` VARCHAR(256) default ''
DEPARTMENT New Fields:
  • `DEP_TITLE` MEDIUMTEXT NOT NULL
DYNAFORM New Fields:
  • `DYN_UPDATE_DATE` DATETIME
EMAIL_SERVERS Updated Fields:
  • `MAIL_TO` VARCHAR(256) default ''
EVENT New Keys:
  • KEY `indexStatusActionProcess`(`EVN_STATUS`, `EVN_ACTION`, `PRO_UID`)
GROUPWF Default Removed:
  • `GRP_UID` VARCHAR(32) NOT NULL
New Fields:
  • `GRP_TITLE` MEDIUMTEXT NOT NULL
INPUT_DOCUMENT New Fields:
  • `INP_DOC_TITLE` MEDIUMTEXT NOT NULL,
  • `INP_DOC_DESCRIPTION` MEDIUMTEXT
LIST_CANCELED Updated Fields:
  • `APP_TITLE` VARCHAR(255) default '',
  • `APP_PRO_TITLE` VARCHAR(255) default '',
  • `APP_TAS_TITLE` VARCHAR(255) default '',
  • `APP_CANCELED_DATE` DATETIME
LIST_COMPLETED Updated Fields:
  • `APP_TITLE` VARCHAR(255) default '',
  • `APP_PRO_TITLE` VARCHAR(255) default '',
  • `APP_TAS_TITLE` VARCHAR(255) default '',
  • `APP_CREATE_DATE` DATETIME,
  • `APP_FINISH_DATE` DATETIME,
New Keys:
  • KEY `usrListCompleted`(`USR_UID`)
LIST_INBOX Updated Fields:
  • `APP_TITLE` VARCHAR(255) default '',
  • `APP_PRO_TITLE` VARCHAR(255) default '',
  • `APP_TAS_TITLE` VARCHAR(255) default '',
  • `APP_UPDATE_DATE` DATETIME
New Keys:
  • KEY `indexUser`(`USR_UID`),
  • KEY `indexInboxUserStatusUpdateDate`(`USR_UID`, `APP_STATUS`, `APP_UPDATE_DATE`)
LIST_PARTICIPATED_LAST New Fields:
  • `DEL_CURRENT_TAS_TITLE` VARCHAR(255) default '' NOT NULL,
New Keys:
  • KEY `usrIndex`(`USR_UID`)
LIST_UNASSIGNED Updated Fields:
  • `DEL_INDEX` INTEGER default 0 NOT NULL,
  • `DEL_PREVIOUS_USR_USERNAME` VARCHAR(100) default '',
  • `DEL_PREVIOUS_USR_FIRSTNAME` VARCHAR(50) default '',
  • `DEL_PREVIOUS_USR_LASTNAME` VARCHAR(50) default '',
  • `APP_UPDATE_DATE` DATETIME NOT NULL,
Updated Keys:
  • PRIMARY KEY (`APP_UID`,`DEL_INDEX`)
LOGIN_LOG New Fields:
  • `LOG_ID` INTEGER NOT NULL AUTO_INCREMENT
Removed Keys:
  • KEY `indexLoginLog`(`USR_UID`, `LOG_INIT_DATE`)
PROCESS New Fields:
  • `PRO_TITLE` MEDIUMTEXT NOT NULL,
  • `PRO_DESCRIPTION` MEDIUMTEXT,
  • `PRO_TRI_OPEN` VARCHAR(32) default '' NOT NULL,
  • `PRO_COST` DECIMAL(7,2) default 0,
  • `PRO_UNIT_COST` VARCHAR(50) default '',
  • `PRO_ITEE` INTEGER default 0 NOT NULL,
  • `PRO_ACTION_DONE` MEDIUMTEXT,
Updated Fields:
  • `PRO_TYPE` VARCHAR(256) default 'NORMAL' NOT NULL
PROCES_VARIABLES New Fields:
  • `INP_DOC_UID` VARCHAR(32) default ''
PRO_REPORTING New Fields:
  • `PRO_COST` DECIMAL(7,2) default 0,
  • `PRO_UNIT_COST` VARCHAR(50) default ''
REPORT_TABLE New Keys:
  • KEY `indexProcessStatus`(`PRO_UID`, `REP_TAB_STATUS`)
SUB_APPLICATION New keys:
  • KEY `DEL_INDEX_PARENT`(`APP_PARENT`)
TASK New Fields:
  • `TAS_TITLE` MEDIUMTEXT NOT NULL,
  • `TAS_DESCRIPTION` MEDIUMTEXT,
  • `TAS_DEF_TITLE` MEDIUMTEXT,
  • `TAS_DEF_SUBJECT_MESSAGE` MEDIUMTEXT,
  • `TAS_DEF_PROC_CODE` MEDIUMTEXT,
  • `TAS_DEF_MESSAGE` MEDIUMTEXT,
  • `TAS_DEF_DESCRIPTION` MEDIUMTEXT,
  • `TAS_NOT_EMAIL_FROM_FORMAT` INTEGER default 0
Updated Fields:
  • `TAS_SELFSERVICE_TIME` INTEGER default 0
New Keys:
  • KEY `indexTasUid`(`TAS_UID`)
USERS New Fields:
  • `USR_COST_BY_HOUR` DECIMAL(7,2) default 0,
  • `USR_UNIT_COST` VARCHAR(50) default '',
  • `USR_PMDRIVE_FOLDER_UID` VARCHAR(32) default '',
  • `USR_BOOKMARK_START_CASES` MEDIUMTEXT,
  • `USR_TIME_ZONE` VARCHAR(100) default '',
  • `USR_DEFAULT_LANG` VARCHAR(10) default '',
  • `USR_LAST_LOGIN` DATETIME,
Removed Fields:
  • `USR_TOTAL_INBOX` INTEGER default 0,
  • `USR_TOTAL_DRAFT` INTEGER default 0,
  • `USR_TOTAL_CANCELLED` INTEGER default 0,
  • `USR_TOTAL_PARTICIPATED` INTEGER default 0,
  • `USR_TOTAL_PAUSED` INTEGER default 0,
  • `USR_TOTAL_COMPLETED` INTEGER default 0,
  • `USR_TOTAL_UNASSIGNED` INTEGER default 0,
  • `USR_COST_BY_HOUR` DECIMAL(7,2) default 0,
  • `USR_UNIT_COST` VARCHAR(50) default '',
USR_REPORTING New Fields:
  • `PRO_COST` DECIMAL(7,2) default 0,
  • `PRO_UNIT_COST` VARCHAR(50) default ''

Database Schema Changes From ProcessMaker 2.8 to 3.1

The following tables describe all the changes that ProcessMaker database schema has suffered since ProcessMaker version 2.8 to 3.1. This changes involve: "New fields added", "Fields Updated", "Default updates" and "Field Type changes". Notice there has not been removal of fields which means that existing records won't get lost when performing an upgrade from ProcessMaker 2.8 to 3.1.

3.1.

New Tables Created

ABE_CONFIGURATION DASHBOARD_DAS_IND LIST_PARTICIPATED_HISTORY MESSAGE_TYPE_VARIABLE
ABE_REQUESTS ELEMENT_TASK_RELATION LIST_PARTICIPATED_LAST NOTIFICATION_DEVICE
ABE_RESPONSES EMAIL_EVENT LIST_PAUSED NOTIFICATION_QUEUE
APP_ASSIGN_SELF_SERVICE_VALUE EMAIL_SERVER LIST_UNASSIGNED PRO_REPORTING
APP_SEQUENCE GMAIL_RELABELING LIST_UNASSIGNED_GROUP SCRIPT_TASK
CASE_CONSOLIDATED LIST_CANCELED MESSAGE_APPLICATION TIMER_EVENT
CATALOG LIST_COMPLETED MESSAGE_EVENT_DEFINITION USR_REPORTING
DASHBOARD LIST_INBOX MESSAGE_EVENT_RELATION WEB_ENTRY_EVENT
DASHBOARD_INDICATOR LIST_MY_INBOX MESSAGE_TYPE

Tables Updated

Table Changes
ADDITIONAL_TABLES Key Added:
  • KEY `indexAdditionalProcess`(`PRO_UID`)
APPLICATION New Fields:
  • `APP_TITLE` MEDIUMTEXT NOT NULL,
  • `APP_DESCRIPTION` MEDIUMTEXT,
  • `APP_DURATION` DOUBLE default 0,
  • `APP_DELAY_DURATION` DOUBLE default 0,
  • `APP_DRIVE_FOLDER_UID` VARCHAR(32) default '',
  • `APP_ROUTING_DATA` MEDIUMTEXT
APP_CACHE_VIEW New Fields:
  • `DEL_RISK_DATE` DATETIME,
Keys Added:
  • KEY `indexAppUid` (`APP_UID`),
  • KEY `indexTasUid` (`TAS_UID`),
  • KEY `indexUsrUid` (`USR_UID`),
  • KEY `indexPrevUsrUid` (`PREVIOUS_USR_UID`),
  • KEY `indexProUid` (`PRO_UID`),
  • KEY `taskUid` (`TAS_UID`),
APP_DELEGATION New Fields:
  • `DEL_RISK_DATE` DATETIME
APP_DOCUMENT New Fields:
  • `APP_DOC_DRIVE_DOWNLOAD` MEDIUMTEXT,
  • `SYNC_WITH_DRIVE` VARCHAR(32) default 'UNSYNCHRONIZED' NOT NULL,
  • `SYNC_PERMISSIONS` MEDIUMTEXT
APP_HISTORY New Fields:
  • `OBJ_TYPE` VARCHAR(20) default 'DYNAFORM' NOT NULL
APP_MESSAGE New Fields:
  • `APP_MSG_ERROR` MEDIUMTEXT
APP_TIMEOUT_ACTION_EXECUTED Default chartset updated: ENGINE=InnoDB ;
BPMN_FLOW New Fields:
  • `FLO_POSITION` INTEGER default 0 NOT NULL,
Fields Updated:
  • Size Incremented `FLO_CONDITION` VARCHAR(512)
BPMN_LANE Foreign Key added:
  • REFERENCES `BPMN_PROJECT` (`PRJ_UID`)
BPMN_PROJECT Fields Updated:
  • `PRJ_TARGET_NAMESPACE` MEDIUMTEXT
CASE_SCHEDULER Fields Added:
  • `SCH_EXECUTION_DATE` DATETIME,
Size Incremented:
  • `SCH_MONTHS` CHAR(27) default '0|0|0|0|0|0|0|0|0|0|0|0' NOT NULL,
CONTENT New Fields:
  • KEY `indexUidLang`(`CON_ID`, `CON_LANG`),
  • KEY `indexCatParUidLang`(`CON_CATEGORY`, `CON_PARENT`, `CON_ID`, `CON_LANG`)
DB_SOURCE Size Incremented:
  • `DBS_PASSWORD` VARCHAR(256) default ''
DEPARTMENT New Fields:
  • `DEP_TITLE` MEDIUMTEXT NOT NULL
DYNAFORM New Fields:
  • `DYN_LABEL` MEDIUMTEXT,
  • `DYN_UPDATE_DATE` DATETIME
FIELDS Fields modified:
  • `FLD_FOREIGN_KEY` TINYINT default 0
GROUPWF New Fields:
  • `GRP_TITLE` MEDIUMTEXT NOT NULL
Default removed
  • `GRP_UID` VARCHAR(32) NOT NULL
INPUT_DOCUMENT New Fields:
  • `INP_DOC_TITLE` MEDIUMTEXT NOT NULL,
  • `INP_DOC_DESCRIPTION` MEDIUMTEXT
LICENSE_MANAGER Fields Updated:
  • `LICENSE_UID` VARCHAR(32) NOT NULL,
  • `LICENSE_USER` VARCHAR(150) default '0' NOT NULL,
  • `LICENSE_START` INTEGER default 0 NOT NULL,
  • `LICENSE_END` INTEGER default 0 NOT NULL,
  • `LICENSE_SPAN` INTEGER default 0 NOT NULL,
  • `LICENSE_STATUS` VARCHAR(100) default '' NOT NULL,
  • `LICENSE_DATA` MEDIUMTEXT NOT NULL,
  • `LICENSE_PATH` VARCHAR(255) default '0' NOT NULL,
  • `LICENSE_WORKSPACE` VARCHAR(32) default '0' NOT NULL,
  • `LICENSE_TYPE` VARCHAR(32) default '0' NOT NULL, PRIMARY KEY (`LICENSE_UID`)
LOGIN_LOG New Fields:
  • `LOG_ID` INTEGER NOT NULL AUTO_INCREMENT,
  • Key removed:
    • KEY `indexLoginLog`(`USR_UID`, `LOG_INIT_DATE`)
PROCESS New Fields:
  • `PRO_TITLE` MEDIUMTEXT NOT NULL,
  • `PRO_DESCRIPTION` MEDIUMTEXT,
  • `PRO_TRI_OPEN` VARCHAR(32) default '' NOT NULL,
  • `PRO_COST` DECIMAL(7,2) default 0,
  • `PRO_UNIT_COST` VARCHAR(50) default '',
  • `PRO_ITEE` INTEGER default 0 NOT NULL,
  • `PRO_ACTION_DONE` MEDIUMTEXT,
Size incremented:
  • `PRO_TYPE` VARCHAR(256) default 'NORMAL' NOT NULL,
PROCESS_VARIABLES New Fields:
  • `INP_DOC_UID` VARCHAR(32) default '',
REPORT_TABLE Keys Added:
  • KEY `indexProcessStatus`(`PRO_UID`, `REP_TAB_STATUS`)
ROUTE New Fields:
  • `ROU_DEFAULT` INTEGER default 0 NOT NULL,
TASK New Fields:
  • `TAS_TITLE` MEDIUMTEXT NOT NULL,
  • `TAS_DESCRIPTION` MEDIUMTEXT,
  • `TAS_DEF_TITLE` MEDIUMTEXT,
  • `TAS_DEF_SUBJECT_MESSAGE` MEDIUMTEXT,
  • `TAS_DEF_PROC_CODE` MEDIUMTEXT,
  • `TAS_DEF_MESSAGE` MEDIUMTEXT,
  • `TAS_DEF_DESCRIPTION` MEDIUMTEXT,
  • `TAS_NOT_EMAIL_FROM_FORMAT` INTEGER default 0,
Size Incremented:
  • `TAS_TYPE` VARCHAR(50) default 'NORMAL' NOT NULL,
Type Changed:
  • `TAS_SELFSERVICE_TIME` INTEGER default 0,
Key Added:
  • KEY `indexTasUid`(`TAS_UID`)
SUB_APPLICATION Key Added:
  • KEY `indexParent`(`APP_PARENT`)
USERS New Fields:
  • `USR_COST_BY_HOUR` DECIMAL(7,2) default 0,
  • `USR_UNIT_COST` VARCHAR(50) default '',
  • `USR_PMDRIVE_FOLDER_UID` VARCHAR(32) default '',
  • `USR_BOOKMARK_START_CASES` MEDIUMTEXT,
  • `USR_TIME_ZONE` VARCHAR(100) default '',
  • `USR_DEFAULT_LANG` VARCHAR(10) default '',
  • `USR_LAST_LOGIN` DATETIME,
Key Added:
  • KEY `indexUsrUid` (`USR_UID`)

Database Schema changes from ProcessMaker 2.5.2 to 3.1

The following tables describe all the changes that ProcessMaker database schema suffered since the ProcessMaker version 2.5.2 to 3.1.

New Tables Created

ABE_CONFIGURATION BPMN_FLOW LICENSE_MANAGER NOTIFICATION_QUEUE
ABE_REQUESTS BPMN_GATEWAY LIST_CANCELED OAUTH_ACCESS_TOKENS
ABE_RESPONSES BPMN_LANE LIST_COMPLETED OAUTH_AUTHORIZATION_CODES
ADDONS_MANAGER BPMN_LANESET LIST_INBOX OAUTH_CLIENTS
ADDONS_STORE BPMN_PARTICIPANT LIST_MY_INBOX OAUTH_REFRESH_TOKENS
APP_ASSIGN_SELF_SERVICE_VALUE BPMN_PROJECT LIST_PARTICIPATED_HISTORY OAUTH_SCOPES
APP_SEQUENCE BPMN_PROCESS LIST_PARTICIPATED_LAST PMOAUTH_USER_ACCESS_TOKENS
APP_TIMEOUT_ACTION_EXECUTED CASE_CONSOLIDATED LIST_PAUSED PRO_REPORTING
BPMN_ACTIVITY CATALOG LIST_UNASSIGNED PROCESS_FILES
BPMN_ARTIFACT DASHBOARD LIST_UNASSIGNED_GROUP PROCESS_VARIABLES
BPMN_BOUND DASHBOARD_INDICATOR MESSAGE_APPLICATION SCRIPT_TASK
BPMN_DATA DASHBOARD_DAS_IND MESSAGE_EVENT_DEFINITION SESSION_STORAGE
BPMN_DIAGRAM ELEMENT_TASK_RELATION MESSAGE_EVENT_RELATION TIMER_EVENT
BPMN_DOCUMENTATION EMAIL_EVENT MESSAGE_TYPE USR_REPORTING
BPMN_EVENT EMAIL_SERVER MESSAGE_TYPE_VARIABLE WEB_ENTRY
BPMN_EXTENSION GMAIL_RELABELING NOTIFICATION_DEVICE WEB_ENTRY_EVENT

Tables Updated

Table Changes
ADDITIONAL_TABLES New Key:
  • KEY `indexAdditionalProcess`(`PRO_UID`)
APPLICATION New fields:
  • `APP_TITLE` MEDIUMTEXT NOT NULL,
  • `APP_DESCRIPTION` MEDIUMTEXT,
  • `APP_DURATION` DOUBLE default 0,
  • `APP_DELAY_DURATION` DOUBLE default 0,
  • `APP_DRIVE_FOLDER_UID` VARCHAR(32) default '',
  • `APP_ROUTING_DATA` MEDIUMTEXT
APP_DELEGATION New Fields:
  • `DEL_RISK_DATE` DATETIME
APP_DOCUMENT New Fields:
  • `APP_DOC_DRIVE_DOWNLOAD` MEDIUMTEXT,
  • `SYNC_WITH_DRIVE` VARCHAR(32) default 'UNSYNCHRONIZED' NOT NULL,
  • `SYNC_PERMISSIONS` MEDIUMTEXT
APP_MESSAGE New Fields:
  • `APP_MSG_ERROR` MEDIUMTEXT
APP_DELAY New Fields:
  • `DBS_CONNECTION_TYPE` VARCHAR(32) default 'NORMAL',
  • `DBS_TNS` VARCHAR(256) default '',
Size Incremented:
  • `DBS_PASSWORD` VARCHAR(256) default ''
APP_CACHE_VIEW New Fields:
  • `DEL_RISK_DATE` DATETIME,
New Keys:
  • KEY `indexAppUid`(`APP_UID`),
  • KEY `indexTasUid`(`TAS_UID`),
  • KEY `indexUsrUid`(`USR_UID`),
  • KEY `indexPrevUsrUid`(`PREVIOUS_USR_UID`),
  • KEY `indexProUid`(`PRO_UID`),
  • KEY `taskUid`(`TAS_UID`),
APP_HISTORY New Fields:
  • `OBJ_TYPE` VARCHAR(20) default 'DYNAFORM' NOT NULL
CASE_SCHEDULER New Fields:
  • `SCH_EXECUTION_DATE` DATETIME,
Updated Fields:
  • `SCH_MONTHS` CHAR(27) default '0|0|0|0|0|0|0|0|0|0|0|0' NOT NULL
CONTENT New Keys:
  • KEY `indexUidLang`(`CON_ID`, `CON_LANG`),
  • KEY `indexCatParUidLang`(`CON_CATEGORY`, `CON_PARENT`, `CON_ID`, `CON_LANG`)
DEPARTMENT New Fields:
  • `DEP_TITLE` MEDIUMTEXT NOT NULL
DYNAFORM New Fields:
  • `DYN_CONTENT` MEDIUMTEXT,
  • `DYN_LABEL` MEDIUMTEXT,
  • `DYN_VERSION` INTEGER NOT NULL,
  • `DYN_UPDATE_DATE` DATETIME,
FIELDS New Fields:
  • `FLD_FOREIGN_KEY` TINYINT default 0,
New Key:
  • KEY `indexStatusActionProcess`(`EVN_STATUS`, `EVN_ACTION`, `PRO_UID`)
GROUPWF New Fields:
  • `GRP_TITLE` MEDIUMTEXT NOT NULL
INPUT_DOCUMENT New Fields:
  • `INP_DOC_TITLE` MEDIUMTEXT NOT NULL,
  • `INP_DOC_DESCRIPTION` MEDIUMTEXT,
  • `INP_DOC_TYPE_FILE` VARCHAR(200) default '*.*',
  • `INP_DOC_MAX_FILESIZE` INTEGER default 0 NOT NULL,
  • `INP_DOC_MAX_FILESIZE_UNIT` VARCHAR(2) default 'KB' NOT NULL,
LOGIN_LOG New Fields:
  • `LOG_ID` INTEGER NOT NULL AUTO_INCREMENT,
Key Updated:
  • From: PRIMARY KEY (`LOG_UID`), KEY `indexLoginLog`(`USR_UID`,`LOG_INIT_DATE`)
    To:
    PRIMARY KEY (`LOG_ID`)
OUTPUT_DOCUMENT New Fields:
  • `OUT_DOC_OPEN_TYPE` INTEGER default 1
PROCESS New Fields:
  • `PRO_TITLE` MEDIUMTEXT NOT NULL,
  • `PRO_DESCRIPTION` MEDIUMTEXT,
  • `PRO_TRI_OPEN` VARCHAR(32) default '' NOT NULL,
  • `PRO_TRI_UNPAUSED` VARCHAR(32) default '' NOT NULL,
  • `PRO_TYPE_PROCESS` VARCHAR(32) default 'PUBLIC' NOT NULL,
  • `PRO_COST` DECIMAL(7,2) default 0,
  • `PRO_UNIT_COST` VARCHAR(50) default '',
  • `PRO_ITEE` INTEGER default 0 NOT NULL,
  • `PRO_ACTION_DONE` MEDIUMTEXT,
Size Incremented:
  • `PRO_TYPE` VARCHAR(256) default 'NORMAL' NOT NULL,
REPORT_TABLE New Keys:
  • KEY `indexProcessStatus`(`PRO_UID`, `REP_TAB_STATUS`)
ROUTE New Fields:
  • `ROU_DEFAULT` INTEGER default 0 NOT NULL
SUB_APPLICATION New Keys:
  • KEY `indexParent`(`APP_PARENT`)

More Information

The default workspace created in ProcessMaker is called workflow, so its database is named wf_workflow. If doing a manual installation of ProcessMaker, the setup screen provides an option to rename this database. See Consulting the ProcessMaker databases for more information about how to access this database with MySQL and phpMyAdmin.

The files for the MySQL databases are generally stored in the following locations:
Linux/UNIX:

The location depends upon your distribution, but it is generally:

/var/lib/mysql/<DATABASE-NAME>/

For example:

/var/lib/mysql/wf_workflow/

Windows:

If installed with the ProcessMaker Windows Installer, the MySQL files are generally stored at:

<INSTALL-DIRECTORY>\MySQL\data\<DATABASE-NAME>\

For example:

C:\Program Files\ProcessMaker\MySQL\data\wf_workflow\

If installed with the manual installation, the MySQL files are generally stored at:

<INSTALL-DIRECTORY>\MySQL\data\<DATABASE-NAME>\

For example:

C:\ProgramData\MySQL\MySQL Server 5.1\data\wf_workflow\