I’d like to change the estimated_effort in the Project Tasks modules from Integer to Decimal. We already have a lot of information saved in the table, so I don’t want to change it and lose that information. What would be the best approach please?
Field Type Integer created a DB Column with Type INT(11), while for Decimal, FLOAT(10,8) (or what every precision you have for the Field).
You can check MySQL ALTER TABLE command with MODIFY arg to update you column. Similarly i think you can do this change in the Extension vardefs for estimated_effort field for Project Tasks module which will have same effect.
Thank you cherubchum, I will have a look at this.