(OK) cBPM-CentOS——Criteria.xml——create-database

    <DataBaseManager>      <Connections>        <MySQL Type="Primary" Id="1">          <PoolManager Min="1" Max="1" Retry="0" Delay="100" />          <Host>127.0.0.1</Host>          <Port></Port>          <User>root</User>          <Password>123456</Password>          <DataBase>criteria</DataBase>          <ObjectManager>            <Object Type="ProcessTemplate" Managed="No">${CRITERIA_HOME}/database/processTemplate</Object>            <Object Type="ProcessInstance" Managed="Yes" />            <Object Type="Reports" Managed="No" />            <Object Type="DataTypes" Managed="No">${CRITERIA_HOME}/database/Criteria.DataTypes.xml</Object>            <Object Type="Services" Managed="No">${CRITERIA_HOME}/database/Criteria.Services.xml</Object>            <Object Type="Users" Managed="No">${CRITERIA_HOME}/database/Criteria.Users.xml</Object>            <Object Type="Roles" Managed="No">${CRITERIA_HOME}/database/Criteria.Roles.xml</Object>            <Object Type="Applications" Managed="No">${CRITERIA_HOME}/database/Criteria.Applications.xml</Object>            <Object Type="ApplicationsDataBase" Managed="Yes" />            <Object Type="Events" Managed="No"></Object>            <Object Type="OccurredEvents" Managed="No"></Object>            <Object Type="WaitingEvents" Managed="No"></Object>          </ObjectManager>        </MySQL>                <!--SQLite Type="Primary" Id="1">          <PoolManager Min="1" Max="1" Retry="0" Delay="50" />          <Path>${CRITERIA_HOME}\database</Path>          <DataBase>Criteria.db</DataBase>          <ObjectManager>                        <Object Type="ProcessTemplate" Managed="No">${CRITERIA_HOME}/database/processTemplate</Object>            <Object Type="ProcessInstance" Managed="Yes" />            <Object Type="Reports" Managed="No" />            <Object Type="DataTypes" Managed="No">${CRITERIA_HOME}/database/Criteria.DataTypes.xml</Object>            <Object Type="Services" Managed="No">${CRITERIA_HOME}/database/Criteria.Services.xml</Object>            <Object Type="Users" Managed="No">${CRITERIA_HOME}/database/Criteria.Users.xml</Object>            <Object Type="Roles" Managed="No">${CRITERIA_HOME}/database/Criteria.Roles.xml</Object>            <Object Type="Applications" Managed="No">${CRITERIA_HOME}/database/Criteria.Applications.xml</Object>            <Object Type="Events" Managed="No"></Object>            <Object Type="OccurredEvents" Managed="No"></Object>            <Object Type="WaitingEvents" Managed="No"></Object>          </ObjectManager>        </SQLite-->        <CriteriaFileSystem Type="Primary" Id="2">          <ObjectManager>                        <Object Type="ProcessTemplate" Managed="Yes" Repository="Folder">${CRITERIA_HOME}/database/processTemplate</Object>            <Object Type="ProcessInstance" Managed="Yes" Repository="Folder">${CRITERIA_HOME}/database/processInstance</Object>            <!-- Object Type="DataTypes" Managed="Yes" Repository="File">${CRITERIA_HOME}/database/Criteria.DataTypes.xml</Object -->            <Object Type="Reports" Managed="No" />            <Object Type="DataTypes" Managed="Yes" Repository="Folder">${CRITERIA_HOME}/database/dataTypes</Object>            <Object Type="Services" Managed="Yes" Repository="File">${CRITERIA_HOME}/database/Criteria.Services.xml</Object>            <Object Type="Users" Managed="Yes" Repository="File">${CRITERIA_HOME}/database/Criteria.Users.xml</Object>            <Object Type="Roles" Managed="Yes" Repository="File">${CRITERIA_HOME}/database/Criteria.Roles.xml</Object>            <!--Object Type="Applications" Managed="Yes" Repository="File">${CRITERIA_HOME}/database/Criteria.Applications.xml</Object-->            <Object Type="Applications" Managed="Yes" Repository="Folder">${CRITERIA_HOME}/database/applications</Object>            <Object Type="ApplicationsDataBase" Managed="No" />            <Object Type="Events" Managed="No"></Object>            <Object Type="OccurredEvents" Managed="No"></Object>            <Object Type="WaitingEvents" Managed="No"></Object>            <Object Type="CheckList" Managed="Yes" Repository="Folder">${CRITERIA_HOME}/database/checkList</Object>          </ObjectManager>        </CriteriaFileSystem>      </Connections>    </DataBaseManager>

++++++++++++++++++++++++++++++

export WF_HOME=/opt/cBPM/criteria-lin/bin/Criteria/Debug/Tools.Executor; export CRITERIA_HOME=/opt/cBPM/criteria-lin/bin/Criteria/Debug/Tools.Executor

[root@localhost criteria-lin]# pwd
/opt/cBPM/criteria-lin

./bin/Criteria/Debug/Tools.Executor/Executor-
./src/Criteria/Criteria.Tools/Criteria.Tools.Executor/Executor-

------------------------------------------------------

[root@localhost criteria-lin]# pwd
/opt/cBPM/criteria-lin

[root@localhost criteria-lin]#


mysql -uroot -p < ./database/scripts/mysql/criteria_mysql.sql
mysql -uroot -p criteria < ./database/scripts/mysql/dm_mysql.sql
mysql -uroot -p criteria < ./database/scripts/mysql/dm_mysql.sql



MariaDB [criteria]>
select * from SF_Activities;
select * from SF_Attributes
select * from SF_DataTypes;
select * from SF_MESSAGEFLOWS;
select * from SF_REPORTS;
select * from SF_Roles;
select * from SF_Services;
select * from SF_Users;
select * from SF_WorkflowProcesses;

select * from dm_attributes;
select * from dm_document_childs;
select * from dm_document_files;
select * from dm_document_versions;
select * from dm_documents;
select * from dm_id_instances;
select * from dm_idinstances_to_recycle;

select * from QRTZ_BLOB_TRIGGERS;
select * from QRTZ_CALENDARS;
select * from QRTZ_CRON_TRIGGERS;
select * from QRTZ_FIRED_TRIGGERS;
select * from QRTZ_JOB_DETAILS;
select * from QRTZ_JOB_LISTENERS;
select * from QRTZ_LOCKS;
select * from QRTZ_PAUSED_TRIGGER_GRPS;
select * from QRTZ_SCHEDULER_STATE;
select * from QRTZ_SIMPLE_TRIGGERS;
select * from QRTZ_TRIGGERS;
select * from QRTZ_TRIGGER_LISTENERS;