L3 - Default AT:
- There is a new table ACT_GE_SCHEMA_LOG
- This table has two columns: ID_ (varchar, primary key), TIMESTAMP_ (date field), VERSION_ (varchar)
- The create script inserts a row into this table with the current version and timestamp
- The 7.11 update script inserts this row as well
- There is a new query API in ManagementService to retrieve schema log entries (returning SchemaLogEntry)
- I can filter the query by: version
- I can order the query by: timestamp
- I can apply limits
- Authorization: I must be member of group camunda-admin for the query to return any results. If I am not member of this group, I get an empty list as result.
- REST API: There is a new resource at path GET /schema/log that exposes the schema log query
- Testing: There is a mechanism that ensures that the schema log always contains entries for the current schema version (two cases: I create the database from scratch; I update an existing database)