Clone Tools
  • last updated a few seconds ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Change uuid types to varchar to allow NiFi to process it

    • -76
    • +48
    ./OlmisCreateTableStatements.sql
Change uuid types to varchar to allow NiFi to process it

    • -76
    • +48
    ./OlmisCreateTableStatements.sql
Fix stock consumption mat view

change role and modify stock mv

    • -56
    • +56
    ./OlmisCreateTableStatements.sql
change role and modify stock mv

    • -63
    • +64
    ./OlmisCreateTableStatements.sql
Update stock consumption materialized views

    • -48
    • +18
    ./OlmisCreateTableStatements.sql
Replace join with left join in materialized view

Make the orderable ID not unique since an orderable can have multiple programs

Update materialized view queries

Update materialized view queries

    • -13
    • +13
    ./OlmisCreateTableStatements.sql
Edit materialied view queries to pull data

Add default table and values and materialized views

    • -2
    • +157
    ./OlmisCreateTableStatements.sql
Add a program column to the facility_access table

  1. … 1 more file in changeset.
Edit table name

  1. … 1 more file in changeset.
changes to sql file

- Changed name of sql file from referenceDataCreateTableStatements to OlmisCreateTableStatements

- Added create table statements for sohlineitems, facility_acess and stock_adjustment_reasons

- Added facility_acess to database.yaml

    • -0
    • +525
    ./OlmisCreateTableStatements.sql
  1. … 3 more files in changeset.