(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;