Index: lams_tool_laqa/db/model/lams_tool_mc.clay =================================================================== diff -u --- lams_tool_laqa/db/model/lams_tool_mc.clay (revision 0) +++ lams_tool_laqa/db/model/lams_tool_mc.clay (revision daec42df4587a260634fd46b948b379fe4c5fdf6) @@ -0,0 +1,820 @@ + + + +QA Tool for Lams 1.1 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+ + + + + Fisheye: Tag daec42df4587a260634fd46b948b379fe4c5fdf6 refers to a dead (removed) revision in file `lams_tool_laqa/db/model/lams_tool_qa.clay'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_tool_laqa/db/sql/activity_insert.sql =================================================================== diff -u -rb167ddc872e456372c2ed2ba4c72eb485a6d0918 -rdaec42df4587a260634fd46b948b379fe4c5fdf6 --- lams_tool_laqa/db/sql/activity_insert.sql (.../activity_insert.sql) (revision b167ddc872e456372c2ed2ba4c72eb485a6d0918) +++ lams_tool_laqa/db/sql/activity_insert.sql (.../activity_insert.sql) (revision daec42df4587a260634fd46b948b379fe4c5fdf6) @@ -43,8 +43,8 @@ VALUES ( NULL -, 'Question and Answer Description' -, 'Question and Answer' +, 'MCQ Description' +, 'MCQ' , 'Put some help text here.' , NULL , NULL @@ -73,7 +73,7 @@ , NULL , NULL , NULL -, 'tool/laqa11/images/icon_questionanswer.swf' +, 'tool/lamc11/images/icon_questionanswer.swf' , NULL , NULL , NULL Index: lams_tool_laqa/db/sql/create_lams_tool_lamc.sql =================================================================== diff -u --- lams_tool_laqa/db/sql/create_lams_tool_lamc.sql (revision 0) +++ lams_tool_laqa/db/sql/create_lams_tool_lamc.sql (revision daec42df4587a260634fd46b948b379fe4c5fdf6) @@ -0,0 +1,121 @@ +CREATE TABLE lams.tl_lamc11_content ( + uid BIGINT(20) NOT NULL AUTO_INCREMENT + , content_id BIGINT(20) NOT NULL + , title VARCHAR(250) NOT NULL DEFAULT 'Multiple Choice' + , instructions VARCHAR(250) NOT NULL DEFAULT 'Please answer the questions until you reach the passmark.' + , creation_date VARCHAR(100) + , update_date DATETIME + , questions_sequenced TINYINT(1) NOT NULL DEFAULT 0 + , username_visible TINYINT(1) NOT NULL DEFAULT 0 + , created_by BIGINT(20) NOT NULL DEFAULT 0 + , monitoring_report_title VARCHAR(100) NOT NULL DEFAULT 'Combined Learner Results' + , report_title VARCHAR(100) NOT NULL DEFAULT 'Multiple Choice' + , run_offline TINYINT(1) NOT NULL DEFAULT 0 + , define_later TINYINT(1) NOT NULL DEFAULT 0 + , synch_in_monitor TINYINT(1) NOT NULL DEFAULT 0 + , offline_instructions VARCHAR(250) NOT NULL DEFAULT 'offline instructions' + , online_instructions VARCHAR(250) NOT NULL DEFAULT 'online instructions' + , end_learning_message VARCHAR(150) NOT NULL DEFAULT 'Thank you!' + , content_in_use TINYINT(1) NOT NULL DEFAULT 0 + , retries TINYINT(1) NOT NULL DEFAULT 0 + , show_feedback TINYINT(1) NOT NULL DEFAULT 0 + , pass_mark INTEGER + , show_report TINYINT(1) NOT NULL DEFAULT 0 + , UNIQUE UQ_tl_lamc11_content_1 (content_id) + , PRIMARY KEY (uid) +)TYPE=InnoDB; + +CREATE TABLE lams.tl_lamc11_que_content ( + uid BIGINT(20) NOT NULL AUTO_INCREMENT + , question VARCHAR(255) + , weight INT(5) NOT NULL DEFAULT 0 + , disabled TINYINT(1) NOT NULL DEFAULT 1 + , feedbackCorrect VARCHAR(255) + , feedbackIncorrect VARCHAR(255) + , display_order INT(5) + , mc_content_id BIGINT(20) NOT NULL + , PRIMARY KEY (uid) + , INDEX (mc_content_id) + , CONSTRAINT FK_tl_lamc11_que_content_1 FOREIGN KEY (mc_content_id) + REFERENCES lams.tl_lamc11_content (uid) +)TYPE=InnoDB; + +CREATE TABLE lams.tl_lamc11_options_content ( + uid BIGINT(20) NOT NULL AUTO_INCREMENT + , correct_option TINYINT(1) NOT NULL DEFAULT 0 + , mc_que_content_id BIGINT(20) NOT NULL + , mc_que_option_text VARCHAR(250) + , PRIMARY KEY (uid) + , INDEX (mc_que_content_id) + , CONSTRAINT FK_tl_lamc11_options_content_1 FOREIGN KEY (mc_que_content_id) + REFERENCES lams.tl_lamc11_que_content (uid) +)TYPE=InnoDB; + +CREATE TABLE lams.tl_lamc11_session ( + uid BIGINT(20) NOT NULL AUTO_INCREMENT + , mc_session_id BIGINT(20) NOT NULL + , session_start_date DATETIME + , session_end_date DATETIME + , session_status VARCHAR(100) + , mc_content_id BIGINT(20) NOT NULL + , UNIQUE UQ_tl_lamc11_session_1 (mc_session_id) + , PRIMARY KEY (uid) + , INDEX (mc_content_id) + , CONSTRAINT FK_tl_lamc_session_1 FOREIGN KEY (mc_content_id) + REFERENCES lams.tl_lamc11_content (uid) +)TYPE=InnoDB; + +CREATE TABLE lams.tl_lamc11_que_usr ( + uid BIGINT(20) NOT NULL AUTO_INCREMENT + , que_usr_id BIGINT(20) NOT NULL + , mc_session_id BIGINT(20) NOT NULL + , username VARCHAR(100) + , fullname VARCHAR(100) + , UNIQUE UQ_tl_lamc11_que_usr_1 (que_usr_id) + , PRIMARY KEY (uid) + , INDEX (mc_session_id) + , CONSTRAINT FK_tl_lamc_tool_usr_1 FOREIGN KEY (mc_session_id) + REFERENCES lams.tl_lamc11_session (uid) +)TYPE=InnoDB; + +CREATE TABLE lams.tl_lamc11_usr_attempt ( + uid BIGINT(20) NOT NULL AUTO_INCREMENT + , que_usr_id BIGINT(20) NOT NULL + , mc_que_content_id BIGINT(20) NOT NULL + , mc_que_option_id BIGINT(20) NOT NULL + , attempt_time DATETIME + , time_zone VARCHAR(255) + , isAttemptCorrect TINYINT(1) NOT NULL DEFAULT 0 + , mark VARCHAR(255) NOT NULL DEFAULT '0' + , passed TINYINT(1) NOT NULL DEFAULT 0 + , attemptOrder INTEGER NOT NULL DEFAULT 1 + , PRIMARY KEY (uid) + , INDEX (que_usr_id) + , CONSTRAINT FK_tl_lamc11_usr_attempt_1 FOREIGN KEY (que_usr_id) + REFERENCES lams.tl_lamc11_que_usr (uid) + , INDEX (mc_que_content_id) + , CONSTRAINT FK_tl_lamc11_usr_attempt_2 FOREIGN KEY (mc_que_content_id) + REFERENCES lams.tl_lamc11_que_content (uid) + , INDEX (mc_que_option_id) + , CONSTRAINT FK_tl_lamc11_usr_attempt_3 FOREIGN KEY (mc_que_option_id) + REFERENCES lams.tl_lamc11_options_content (uid) +)TYPE=InnoDB; + +CREATE TABLE lams.tl_lamc11_uploadedFile ( + uid BIGINT(20) NOT NULL AUTO_INCREMENT + , uuid VARCHAR(255) NOT NULL + , mc_content_id BIGINT(20) NOT NULL + , isOnline_File TINYINT(1) NOT NULL + , filename VARCHAR(255) NOT NULL + , PRIMARY KEY (uid) + , INDEX (mc_content_id) + , CONSTRAINT FK_tl_lamc11_uploadedFile FOREIGN KEY (mc_content_id) + REFERENCES lams.tl_lamc11_content (uid) +)TYPE=InnoDB; + + +INSERT INTO lams.tl_lamc11_content(uid, content_id , title , instructions , creation_date , questions_sequenced , username_visible , created_by , monitoring_report_title , report_title , run_offline , define_later, synch_in_monitor, offline_instructions, online_instructions, end_learning_message, content_in_use, retries, show_feedback, show_report) VALUES (1, ${default_content_id} ,'Mc Title','Mc Instructions', NOW(), 0, 0,1,'Monitoring Report','Report', 0, 0, 0,'offline instructions','instructions','Finished Activity...', 0, 0, 0, 0); + +INSERT INTO lams.tl_lamc11_que_content (uid,question, weight, disabled, display_order, mc_content_id) VALUES (1, 'a sample question', 0, 1, 1, 1); + +INSERT INTO lams.tl_lamc11_options_content (uid, correct_option, mc_que_content_id, mc_que_option_text) VALUES (1, 0, 1,'sample answer 1'); \ No newline at end of file Fisheye: Tag daec42df4587a260634fd46b948b379fe4c5fdf6 refers to a dead (removed) revision in file `lams_tool_laqa/db/sql/create_lams_tool_qa.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_tool_laqa/db/sql/drop_lams_tool_lamc.sql =================================================================== diff -u --- lams_tool_laqa/db/sql/drop_lams_tool_lamc.sql (revision 0) +++ lams_tool_laqa/db/sql/drop_lams_tool_lamc.sql (revision daec42df4587a260634fd46b948b379fe4c5fdf6) @@ -0,0 +1,16 @@ + +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; + + + + + + + + Fisheye: Tag daec42df4587a260634fd46b948b379fe4c5fdf6 refers to a dead (removed) revision in file `lams_tool_laqa/db/sql/drop_lams_tool_qa.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_tool_laqa/db/sql/insert_lams_tool_lamc.sql =================================================================== diff -u --- lams_tool_laqa/db/sql/insert_lams_tool_lamc.sql (revision 0) +++ lams_tool_laqa/db/sql/insert_lams_tool_lamc.sql (revision daec42df4587a260634fd46b948b379fe4c5fdf6) @@ -0,0 +1 @@ \ No newline at end of file Fisheye: Tag daec42df4587a260634fd46b948b379fe4c5fdf6 refers to a dead (removed) revision in file `lams_tool_laqa/db/sql/insert_tool_qa_data.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_tool_laqa/db/sql/library_insert.sql =================================================================== diff -u -rf1e14548cbdc97c2000d1f697271b093018575f3 -rdaec42df4587a260634fd46b948b379fe4c5fdf6 --- lams_tool_laqa/db/sql/library_insert.sql (.../library_insert.sql) (revision f1e14548cbdc97c2000d1f697271b093018575f3) +++ lams_tool_laqa/db/sql/library_insert.sql (.../library_insert.sql) (revision daec42df4587a260634fd46b948b379fe4c5fdf6) @@ -11,8 +11,8 @@ ) VALUES ( -'Question and Answer Learning Library Description', -'Question and Answer', +'MCQ Learning Library Description', +'MCQ', 0, NOW() ) Fisheye: Tag daec42df4587a260634fd46b948b379fe4c5fdf6 refers to a dead (removed) revision in file `lams_tool_laqa/db/sql/tl_laqa11_uploadedFile.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag daec42df4587a260634fd46b948b379fe4c5fdf6 refers to a dead (removed) revision in file `lams_tool_laqa/db/sql/tl_laqa11_uploadedFiles.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_tool_laqa/db/sql/tool_insert.sql =================================================================== diff -u -rb167ddc872e456372c2ed2ba4c72eb485a6d0918 -rdaec42df4587a260634fd46b948b379fe4c5fdf6 --- lams_tool_laqa/db/sql/tool_insert.sql (.../tool_insert.sql) (revision b167ddc872e456372c2ed2ba4c72eb485a6d0918) +++ lams_tool_laqa/db/sql/tool_insert.sql (.../tool_insert.sql) (revision daec42df4587a260634fd46b948b379fe4c5fdf6) @@ -29,11 +29,11 @@ ) VALUES ( -'laqa11', -'qaService', -'Question and Answer', -'Question and Answer Tool Description', -'qa', +'lamc11', +'mcService', +'MCQ', +'MCQ Tool Description', +'mc', '1.1', NULL, 10, @@ -43,12 +43,12 @@ 1, 1, 0, -'tool/laqa11/learningStarter.do', -'tool/laqa11/authoringStarter.do', -'tool/laqa11/definelater.do', -'tool/laqa11/export.do', -'tool/laqa11/monitoringStarter.do', -'tool/laqa11/monitoringStarter.do', -'tool/laqa11/monitoringStarter.do', +'tool/lamc11/learningStarter.do', +'tool/lamc11/authoringStarter.do', +'tool/lamc11/definelater.do', +'tool/lamc11/export.do', +'tool/lamc11/monitoringStarter.do', +'tool/lamc11/monitoringStarter.do', +'tool/lamc11/monitoringStarter.do', NOW() )