Database version
Database table TIDMA_DB_HISTORY
The table TIDMA_DB_HISTORY contains the history of all applied database migrations. Database migrations take place between releases of nevisIDM, when upgrading your nevisIDM application to a new version. It is possible to have multiple database schema migrations in between releases, where each migration is represented by a single row in the table, having a distinct version number.
| DB attribute | Java data type (max. size), defaults | Description |
|---|---|---|
| installed_rank | integer, not NULL | Primary key. Defines the position of this migration in the sequence of all performed migration events. It is used for out-of-order detection. |
| version | string(50), nullable | The target version of this migration. |
| description | string(200), not NULL | The description of the migration. |
| type | string(20), not NULL | The type of migration (INIT, SQL, ...). |
| script | string(1000), not NULL | The name of the script to execute for this migration. |
| checksum | integer, nullable | The checksum of the migration. |
| installed_by | string(1000), not NULL | The user that installed this migration. |
| installed_on | date, not NULL | The timestamp when this migration was installed. |
| execution_time | integer, not NULL | The execution time (in milliseconds) of this migration. |
| success | integer, not NULL | Flag indicating whether the migration was successful (1) or not (0). |
The table TIDMA_DB_HISTORY exists starting from nevisIDM version 2.75.x. For migrations of older database versions, see the description of the table TIDMA_DB_VERSION_LOG below.
Database table TIDMA_DB_VERSION_LOG (legacy)
The database version log table TIDMA_DB_VERSION_LOG holds a list of all patches applied to the database until nevisIDM version 2.75.x. The table contains a row for each patch.
| DB attribute | Java data type (max. size), defaults | Description |
|---|---|---|
| db_version_log_id | Long, not NULL | Primary key (uniquely identifies each in |
| install_end_dat | date, nullable | The date when the run of the patch was finished. |
| install_start_dat | date, not NULL | The date when the patch was started. |
| install_type | string(16), not NULL | "created" if the database was created and "patch" for applied patches. |
| version | String(32), not NULL | Version number of the applied patch. |