Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch2040068.sql =================================================================== diff -u --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch2040068.sql (revision 0) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch2040068.sql (revision 825714b6ed808f5818800bf9fba90876ec44637b) @@ -0,0 +1,13 @@ +-- Turn off autocommit, so nothing is committed if there is an error + +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; + +-- LDEV-3292 Add indexes, as prompted by a client +ALTER TABLE tl_lafrum11_forum_user ADD INDEX idx_user_id (user_id); +ALTER TABLE lams_notebook_entry ADD INDEX idx_create_date (create_date); + +-- If there were no errors, commit and restore autocommit to on +SET FOREIGN_KEY_CHECKS=0; +COMMIT; +SET AUTOCOMMIT = 1;