Index: lams_common/db/sql/create_lams_11_tables.sql
===================================================================
diff -u -r9dd2af2b02ec99dd3490c39cdd634b6c77f0527c -r747ca68c982acc647cc5e277ae967489e684d7b4
--- lams_common/db/sql/create_lams_11_tables.sql	(.../create_lams_11_tables.sql)	(revision 9dd2af2b02ec99dd3490c39cdd634b6c77f0527c)
+++ lams_common/db/sql/create_lams_11_tables.sql	(.../create_lams_11_tables.sql)	(revision 747ca68c982acc647cc5e277ae967489e684d7b4)
@@ -852,17 +852,6 @@
                   REFERENCES lams_learning_activity (activity_id)
 )ENGINE=InnoDB;
 
-CREATE TABLE lams_lesson_learner (
-       lesson_id BIGINT(20) NOT NULL
-     , user_id BIGINT(20) NOT NULL
-     , INDEX (lesson_id)
-     , CONSTRAINT FK_lams_lesson_learner_1 FOREIGN KEY (lesson_id)
-                  REFERENCES lams_lesson (lesson_id)
-     , INDEX (user_id)
-     , CONSTRAINT FK_lams_lesson_learner_2 FOREIGN KEY (user_id)
-                  REFERENCES lams_user (user_id)
-)ENGINE=InnoDB;
-
 CREATE TABLE lams_cr_workspace_credential (
        wc_id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT
      , workspace_id BIGINT(20) UNSIGNED NOT NULL
Index: lams_common/db/sql/drop_lams_11_tables.sql
===================================================================
diff -u -r009fbce36f45d0929f8007c4bbc798242f57d3af -r747ca68c982acc647cc5e277ae967489e684d7b4
--- lams_common/db/sql/drop_lams_11_tables.sql	(.../drop_lams_11_tables.sql)	(revision 009fbce36f45d0929f8007c4bbc798242f57d3af)
+++ lams_common/db/sql/drop_lams_11_tables.sql	(.../drop_lams_11_tables.sql)	(revision 747ca68c982acc647cc5e277ae967489e684d7b4)
@@ -28,7 +28,6 @@
 DROP TABLE IF EXISTS lams_learning_transition;
 DROP TABLE IF EXISTS lams_learning_library;
 DROP TABLE IF EXISTS lams_lesson;
-DROP TABLE IF EXISTS lams_lesson_learner;
 DROP TABLE IF EXISTS lams_lesson_state;
 DROP TABLE IF EXISTS lams_license;
 DROP TABLE IF EXISTS lams_log_event;
Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch2040047.sql
===================================================================
diff -u
--- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch2040047.sql	(revision 0)
+++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch2040047.sql	(revision 747ca68c982acc647cc5e277ae967489e684d7b4)
@@ -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-2903 Remove the table as it is never used
+DROP TABLE IF EXISTS lams_lesson_learner;
+
+-- If there were no errors, commit and restore autocommit to on
+SET FOREIGN_KEY_CHECKS=0;
+COMMIT;
+SET AUTOCOMMIT = 1;
\ No newline at end of file