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.

	Version	To	To	To	To
	DB Version	5.8.0- latest	5.6.0-5.7.x	5.0.x-5.5.x	4.x	Remarks
Version from
5.8.0-5.8.x	5800		DG-5600	DG-5600		-
5.7.0-5.7.x	5600					-
5.6.0-5.6.x	5600					-
5.0-5.5.x	(8.0)					-

 Use downgrade queries     Nothing required / nothing to do      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.