This is an old revision of the document!
This is currently a work in progress. It will be updated as and when I get time or the checked in code's functionally changes.
If you give a user
g_time_tracking_edit_threshold you must give them
The time tracking information is attached to issue notes. Currently it is using an INT column type to hold the number of minutes.
admin/schema.php has an update to add this column to the database.
ALTER TABLE mantis_bugnote_table ADD COLUMN time_tracking TIME DEFAULT 0;
In previous versions the time_tracking column was held as a MySQL TIME column type. If you are using a CVS version and would like to upgrade to using the INT column, then the following SQL will help you convert the information to the new column type.
ALTER TABLE mantis_bugnote_table ADD COLUMN time_tracking_t INT DEFAULT 0; UPDATE bugnote_table SET time_tracking_t = (HOUR(time_tracking)*60) + (MINUTE(time_tracking)) + IF(SECOND(time_tracking)>30,1,0); ALTER TABLE mantis_bugnote_table DROP COLUMN time_tracking; ALTER TABLE mantis_bugnote_table CHANGE time_tracking_t time_tracking INT DEFAULT 0;
Please write your feedback here.