Important note Retirement of icTime and Retirement of biz on December 29th, 2023

Downgrading ictime

Database Up- / Downgrade Version Matrix

Upgrading ictime to a higher version does not require any database changes performed by the user. All necessary database changes are applied during plugin startup automatically.


VersionToTo

To

To

DB Version5.8.0- latest5.6.0-5.7.x

5.0.x-5.5.x

4.xRemarks
Version from





5.8.0-5.8.x5800(star)(plus) DG-5600(plus) DG-5600(minus)-
5.7.0-5.7.x5600(star)(star)(star)(minus)-
5.6.0-5.6.x

5600

(star)(star)(star)(minus)-
5.0-5.5.x(8.0)(star)(star)(star)(minus)-

(plus) Use downgrade queries    (star) Nothing required / nothing to do     (minus) Not possible and not supported. Use a backup instead. 


SQL-Query Downgrade Steps

All database queries provided in  MySQL Query language. Please adapt query to SQL syntax according to your database engine (PostgreSQL, Oracle, MsSQL),

DG-5800

Database version 5800 is the latest. No downgrade exists at this time.

DG-5600

Usage

Run following database query:

update AO_9B23C2_TIME_ENTRY set Auto_Generated = null where Auto_Generated not in ('APPROVAL', 'INVOICE');  

Remarks / Implications

No Implications. The field just contains an internal value, which is NOT present in ictime version prior 5.6.x. Null values are acceptable in all versions.