Index: lams_common/db/model/lams_11.clay
===================================================================
diff -u -r7b79396263b36a933d66390fb9ab12821956d59d -r8500d5f6f649e1a77393430e5ff969cc7562bd39
--- lams_common/db/model/lams_11.clay	(.../lams_11.clay)	(revision 7b79396263b36a933d66390fb9ab12821956d59d)
+++ lams_common/db/model/lams_11.clay	(.../lams_11.clay)	(revision 8500d5f6f649e1a77393430e5ff969cc7562bd39)
@@ -3807,59 +3807,6 @@
 </foreign-key-list>
 <index-list/>
 </table>
-<table alias="" name="lams_lesson_learner" remarks="" uid="7725df:115cb718d5c:-7b67">
-<table-description/>
-<table-figure-bounds height="-1" width="-1" x="278" y="408"/>
-<column-list>
-<column alias="" auto-increment="false" column-size="20" decimal-digits="0" default-value="" mandatory="true" name="lesson_id" remarks="" uid="7725df:115cb718d5c:-7b65">
-<column-description/>
-<data-type jdbc-type="-5" name="BIGINT" selected-variant-pattern="BIGINT(%n)">
-<variant precision-max="19" precision-min="0" precision-variable="%n" type-name-pattern="BIGINT(%n)"/>
-<variant type-name-pattern="BIGINT"/>
-<variant precision-max="19" precision-min="0" precision-variable="%n" type-name-pattern="BIGINT(%n) UNSIGNED"/>
-<variant precision-max="19" precision-min="0" precision-variable="%n" type-name-pattern="BIGINT(%n) UNSIGNED ZEROFILL"/>
-<variant precision-max="19" precision-min="0" precision-variable="%n" type-name-pattern="BIGINT(%n) ZEROFILL"/>
-<variant type-name-pattern="BIGINT UNSIGNED"/>
-<variant type-name-pattern="BIGINT UNSIGNED ZEROFILL"/>
-<variant type-name-pattern="BIGINT ZEROFILL"/>
-</data-type>
-</column>
-<column alias="" auto-increment="false" column-size="20" decimal-digits="0" default-value="" mandatory="true" name="user_id" remarks="" uid="7725df:115cb718d5c:-7b64">
-<column-description/>
-<data-type jdbc-type="-5" name="BIGINT" selected-variant-pattern="BIGINT(%n)">
-<variant precision-max="19" precision-min="0" precision-variable="%n" type-name-pattern="BIGINT(%n)"/>
-<variant type-name-pattern="BIGINT"/>
-<variant precision-max="19" precision-min="0" precision-variable="%n" type-name-pattern="BIGINT(%n) UNSIGNED"/>
-<variant precision-max="19" precision-min="0" precision-variable="%n" type-name-pattern="BIGINT(%n) UNSIGNED ZEROFILL"/>
-<variant precision-max="19" precision-min="0" precision-variable="%n" type-name-pattern="BIGINT(%n) ZEROFILL"/>
-<variant type-name-pattern="BIGINT UNSIGNED"/>
-<variant type-name-pattern="BIGINT UNSIGNED ZEROFILL"/>
-<variant type-name-pattern="BIGINT ZEROFILL"/>
-</data-type>
-</column>
-</column-list>
-<primary-key alias="" name="PK_LAMS_LESSON_LEARNER" remarks="" uid="7725df:115cb718d5c:-7b66">
-<primary-key-description/>
-</primary-key>
-<unique-key-list/>
-<foreign-key-list>
-<foreign-key alias="" name="FK_lams_lesson_learner_1" on-delete="" on-update="" referenced-key="PK_LAMS_LESSON" referenced-table="lams_lesson" referenced-table-schema="DEFAULT_SCHEMA" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="7725df:115cb718d5c:-7a5c">
-<foreign-key-description/>
-<foreign-key-figure>
-<fk-fig-bendpoint-list/>
-</foreign-key-figure>
-<foreign-key-column column-name="lesson_id" referenced-key-column-name="lesson_id"/>
-</foreign-key>
-<foreign-key alias="" name="FK_lams_lesson_learner_2" on-delete="" on-update="" referenced-key="PRIMARY" referenced-table="lams_user" referenced-table-schema="DEFAULT_SCHEMA" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="7725df:115cb718d5c:-7a5b">
-<foreign-key-description/>
-<foreign-key-figure>
-<fk-fig-bendpoint-list/>
-</foreign-key-figure>
-<foreign-key-column column-name="user_id" referenced-key-column-name="user_id"/>
-</foreign-key>
-</foreign-key-list>
-<index-list/>
-</table>
 <table alias="" name="lams_tool_session_type" remarks="" uid="7725df:115cb718d5c:-7b63">
 <table-description/>
 <table-figure-bounds height="-1" width="-1" x="1265" y="628"/>
Index: lams_common/db/sql/create_lams_11_tables.sql
===================================================================
diff -u -ra7b8600cfd047060de28c119b09c0ca13222ff5b -r8500d5f6f649e1a77393430e5ff969cc7562bd39
--- lams_common/db/sql/create_lams_11_tables.sql	(.../create_lams_11_tables.sql)	(revision a7b8600cfd047060de28c119b09c0ca13222ff5b)
+++ lams_common/db/sql/create_lams_11_tables.sql	(.../create_lams_11_tables.sql)	(revision 8500d5f6f649e1a77393430e5ff969cc7562bd39)
@@ -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 -r8500d5f6f649e1a77393430e5ff969cc7562bd39
--- 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 8500d5f6f649e1a77393430e5ff969cc7562bd39)
@@ -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 8500d5f6f649e1a77393430e5ff969cc7562bd39)
@@ -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