Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch2040044.sql
===================================================================
diff -u
--- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch2040044.sql	(revision 0)
+++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch2040044.sql	(revision 1801813d29da5db69f1efdf371af3b980d692422)
@@ -0,0 +1,12 @@
+-- Turn off autocommit, so nothing is committed if there is an error
+
+SET AUTOCOMMIT = 0;
+SET FOREIGN_KEY_CHECKS=0;
+
+-- LDEV-3292 Add a vital index for notebook entries
+CREATE INDEX ext_sig_user ON lams_notebook_entry(external_id, external_id_type, external_signature, user_id); 
+
+-- If there were no errors, commit and restore autocommit to on
+SET FOREIGN_KEY_CHECKS=0;
+COMMIT;
+SET AUTOCOMMIT = 1;