Index: lams_build/lib/lams/lams-learning.jar =================================================================== diff -u -r3dbf966d900adefc34cdad501d3c392118451cd9 -re463b64cccfefc6efb39c891fb496bfed47feb4a Binary files differ Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch2040066.sql =================================================================== diff -u --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch2040066.sql (revision 0) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch2040066.sql (revision e463b64cccfefc6efb39c891fb496bfed47feb4a) @@ -0,0 +1,18 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; + +-- LDEV-3765 Create a table for storing commands sent to Learners +-- No foreign keys as maybe in the future it will be possible to send commands to a learner in any lesson +-- or to all learners in a given lesson. + +CREATE TABLE lams_learning_command ( + uid BIGINT(20) NOT NULL AUTO_INCREMENT, + lesson_id BIGINT(20), + user_name VARCHAR(191), + create_date DATETIME NOT NULL, + command_text TEXT, + PRIMARY KEY (uid) +)ENGINE=InnoDB; + +COMMIT; +SET AUTOCOMMIT = 1; Index: lams_learning/build.xml =================================================================== diff -u -r3665dab7c4bd5cd4584c4348a7960722bede3d9a -re463b64cccfefc6efb39c891fb496bfed47feb4a --- lams_learning/build.xml (.../build.xml) (revision 3665dab7c4bd5cd4584c4348a7960722bede3d9a) +++ lams_learning/build.xml (.../build.xml) (revision e463b64cccfefc6efb39c891fb496bfed47feb4a) @@ -6,11 +6,11 @@ -