OLE DB Refresh Process & Changes

OLE has three different application schemas for OLEFS, OLELS and OLEDOCSTORE respectively. All the three different schemas come with a baseline dataset that is required for the applications basic functionality. Details of individual application schemas, baseline data sets and process for adding or updating different tables in the respective schemas has been explained below;

OLEFS - The main db module in OLEFS can be located under ole-app/ole-db

The four different maven modules for OLEFS DB are as follows;

1. ole-impex - This module contains information about the baseline KFS/Rice datasets
   1. ole-impex-master - This module has all the table definitions (schema.xml) along with data xml files for the base KFS datasets. This doesn't have any Rice related tables or data.
   2. ole-impex-rice - This module strictly contains the Rice table definitions (schema.xml) along with data xml files.
2. ole-liquibase - This module contains information about any database changes or updates that need to be made
   1. ole-liquibase-changeset - This module contains the definitions for any updates that needs to be made to the base OLE schema that contains the base KFS/Rice tables/data. The updates could include creation of new tables, populating with same data etc..

      ole-sql

      Do not hand type or update the sql files under the ole-sql folder. These are auto generated depending on the contents from ole-impex and ole-liquibase modules.

3. ole-sql - SQL Files under the various sub-modules are auto-generated by maven commands run under the modules in 1 & 2.
   1. ole-liquibase-sql
   2. ole-master-sql
   3. ole-rice-sql
4. ole-workflow - 

OLELS

OLEDOCSTORE