Index: lams_tool_lamc/db/sql/activity_insert.sql =================================================================== diff -u -r5be03595a347709c737d01bdaec5cbc986c04040 -r1e2c58c34d6b4e5d44b54e100f742d22a1b514a0 --- lams_tool_lamc/db/sql/activity_insert.sql (.../activity_insert.sql) (revision 5be03595a347709c737d01bdaec5cbc986c04040) +++ lams_tool_lamc/db/sql/activity_insert.sql (.../activity_insert.sql) (revision 1e2c58c34d6b4e5d44b54e100f742d22a1b514a0) @@ -43,8 +43,8 @@ VALUES ( NULL -, 'MCQ Description' -, 'MCQ' +, 'Allows creation and use of multiple choice questioning format' +, 'Multiple Choice Questions' , 'Put some help text here.' , NULL , NULL @@ -73,7 +73,7 @@ , NULL , NULL , NULL -, 'tool/lamc11/images/icon_questionanswer.swf' +, 'tool/lamc11/images/icon_mcq.swf' , NULL , NULL , NULL Index: lams_tool_lamc/db/sql/drop_lams_tool_mc.sql =================================================================== diff -u -r784a72683b6ab8df50473379b2c92f626498cb21 -r1e2c58c34d6b4e5d44b54e100f742d22a1b514a0 --- lams_tool_lamc/db/sql/drop_lams_tool_mc.sql (.../drop_lams_tool_mc.sql) (revision 784a72683b6ab8df50473379b2c92f626498cb21) +++ lams_tool_lamc/db/sql/drop_lams_tool_mc.sql (.../drop_lams_tool_mc.sql) (revision 1e2c58c34d6b4e5d44b54e100f742d22a1b514a0) @@ -1,16 +1,18 @@ +USE lams; +SET FOREIGN_KEY_CHECKS=0; DROP TABLE lams.tl_lamc11_uploadedFile; DROP TABLE lams.tl_lamc11_usr_attempt; DROP TABLE lams.tl_lamc11_que_usr; DROP TABLE lams.tl_lamc11_session; DROP TABLE lams.tl_lamc11_options_content; DROP TABLE lams.tl_lamc11_que_content; DROP TABLE lams.tl_lamc11_content; +SET FOREIGN_KEY_CHECKS=1; - Index: lams_tool_lamc/db/sql/tool_insert.sql =================================================================== diff -u -r5be03595a347709c737d01bdaec5cbc986c04040 -r1e2c58c34d6b4e5d44b54e100f742d22a1b514a0 --- lams_tool_lamc/db/sql/tool_insert.sql (.../tool_insert.sql) (revision 5be03595a347709c737d01bdaec5cbc986c04040) +++ lams_tool_lamc/db/sql/tool_insert.sql (.../tool_insert.sql) (revision 1e2c58c34d6b4e5d44b54e100f742d22a1b514a0) @@ -32,11 +32,11 @@ 'lamc11', 'mcService', 'MCQ', -'MCQ Tool Description', +'Multiple Choice Questions', 'mc', '1.1', NULL, -10, +NULL, 0, 2, 1,