Index: lams_tool_lamc/db/model/lams_tool_mc.clay
===================================================================
diff -u -r127c05cdcc1e19906d3f978d5d308b4e0218ec13 -r931d25448a093526a8263a167bd2b8d1104eb04b
--- lams_tool_lamc/db/model/lams_tool_mc.clay (.../lams_tool_mc.clay) (revision 127c05cdcc1e19906d3f978d5d308b4e0218ec13)
+++ lams_tool_lamc/db/model/lams_tool_mc.clay (.../lams_tool_mc.clay) (revision 931d25448a093526a8263a167bd2b8d1104eb04b)
@@ -729,7 +729,7 @@
-
+
Index: lams_tool_lamc/db/sql/create_lams_tool_mc.sql
===================================================================
diff -u -r127c05cdcc1e19906d3f978d5d308b4e0218ec13 -r931d25448a093526a8263a167bd2b8d1104eb04b
--- lams_tool_lamc/db/sql/create_lams_tool_mc.sql (.../create_lams_tool_mc.sql) (revision 127c05cdcc1e19906d3f978d5d308b4e0218ec13)
+++ lams_tool_lamc/db/sql/create_lams_tool_mc.sql (.../create_lams_tool_mc.sql) (revision 931d25448a093526a8263a167bd2b8d1104eb04b)
@@ -1,4 +1,4 @@
-CREATE TABLE lams.tl_lamc11_content (
+CREATE TABLE tl_lamc11_content (
uid BIGINT(20) NOT NULL AUTO_INCREMENT
, content_id BIGINT(20) NOT NULL
, title TEXT NOT NULL
@@ -25,7 +25,7 @@
, PRIMARY KEY (uid)
)TYPE=InnoDB;
-CREATE TABLE lams.tl_lamc11_que_content (
+CREATE TABLE tl_lamc11_que_content (
uid BIGINT(20) NOT NULL AUTO_INCREMENT
, question VARCHAR(255)
, weight INT(5) NOT NULL DEFAULT 0
@@ -37,21 +37,21 @@
, 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)
+ REFERENCES tl_lamc11_content (uid)
)TYPE=InnoDB;
-CREATE TABLE lams.tl_lamc11_options_content (
+CREATE TABLE 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)
+ REFERENCES tl_lamc11_que_content (uid)
)TYPE=InnoDB;
-CREATE TABLE lams.tl_lamc11_session (
+CREATE TABLE tl_lamc11_session (
uid BIGINT(20) NOT NULL AUTO_INCREMENT
, mc_session_id BIGINT(20) NOT NULL
, session_start_date DATETIME
@@ -62,10 +62,10 @@
, PRIMARY KEY (uid)
, INDEX (mc_content_id)
, CONSTRAINT FK_tl_lamc_session_1 FOREIGN KEY (mc_content_id)
- REFERENCES lams.tl_lamc11_content (uid)
+ REFERENCES tl_lamc11_content (uid)
)TYPE=InnoDB;
-CREATE TABLE lams.tl_lamc11_que_usr (
+CREATE TABLE 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
@@ -75,10 +75,10 @@
, 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)
+ REFERENCES tl_lamc11_session (uid)
)TYPE=InnoDB;
-CREATE TABLE lams.tl_lamc11_usr_attempt (
+CREATE TABLE 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
@@ -92,30 +92,30 @@
, 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)
+ REFERENCES 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)
+ REFERENCES 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)
+ REFERENCES tl_lamc11_options_content (uid)
)TYPE=InnoDB;
-CREATE TABLE lams.tl_lamc11_uploadedFile (
+CREATE TABLE 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)
+ , CONSTRAINT FK_tl_lamc11_uploadedfile FOREIGN KEY (mc_content_id)
+ REFERENCES 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','online instructions','Finished Activity...', 0, 0, 0, 0);
+INSERT INTO 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','online 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 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');
+INSERT INTO tl_lamc11_options_content (uid, correct_option, mc_que_content_id, mc_que_option_text) VALUES (1, 0, 1,'sample answer 1');