Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20200626.sql =================================================================== diff -u --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20200626.sql (revision 0) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20200626.sql (revision f45ff812d6ff32392c6b61325be585eac8cc9c14) @@ -0,0 +1,15 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +-- Put all sql statements below here + +--LDEV-5047 Make numeric option more accurate as with large numbers it performs rounding + +ALTER TABLE lams_qb_option MODIFY COLUMN numerical_option DOUBLE; + +-- Put all sql statements above here + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; Fisheye: Tag f45ff812d6ff32392c6b61325be585eac8cc9c14 refers to a dead (removed) revision in file `lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20200626.sql'. Fisheye: No comparison available. Pass `N' to diff?