Index: lams_tool_laqa/db/sql/create_lams_tool_qa.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/db/sql/create_lams_tool_qa.sql,v diff -u -r1.50 -r1.51 --- lams_tool_laqa/db/sql/create_lams_tool_qa.sql 4 Nov 2008 00:41:19 -0000 1.50 +++ lams_tool_laqa/db/sql/create_lams_tool_qa.sql 4 Nov 2008 05:17:02 -0000 1.51 @@ -131,7 +131,6 @@ alter table tl_laqa11_wizard_question add index FKAF08A0C7EFF77FD4 (cognitive_skill_uid), add constraint FKAF08A0C7EFF77FD4 foreign key (cognitive_skill_uid) references tl_laqa11_wizard_cognitive_skill (uid); -- Inserting the required config item into the config table --- Gmap API key is added here for shaun so the Gmap works there automatically for each build INSERT INTO tl_laqa11_configuration ( config_key, config_value Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20080926_updateFrom21.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20080926_updateFrom21.sql,v diff -u -r1.3 -r1.4 --- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20080926_updateFrom21.sql 30 Oct 2008 22:52:49 -0000 1.3 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20080926_updateFrom21.sql 4 Nov 2008 05:15:50 -0000 1.4 @@ -22,4 +22,32 @@ UPDATE lams_tool SET supports_outputs=1 WHERE tool_signature='laqa11'; -- Condition copies created for branch activity entries won't have links to any existing Q&A contents. -ALTER TABLE tl_laqa11_que_content MODIFY COLUMN qa_content_id BIGINT(20); \ No newline at end of file +ALTER TABLE tl_laqa11_que_content MODIFY COLUMN qa_content_id BIGINT(20); + +SET FOREIGN_KEY_CHECKS=0; +-- insert scripts for the wizard tables +drop table if exists tl_laqa11_configuration; +drop table if exists tl_laqa11_wizard_category; +drop table if exists tl_laqa11_wizard_cognitive_skill; +drop table if exists tl_laqa11_wizard_question; +create table tl_laqa11_configuration (uid bigint not null auto_increment, config_key varchar(30) unique, config_value varchar(255), primary key (uid))TYPE=InnoDB; +create table tl_laqa11_wizard_category (uid bigint not null auto_increment, title varchar(255) not null, primary key (uid))TYPE=InnoDB; +create table tl_laqa11_wizard_cognitive_skill (uid bigint not null auto_increment, title varchar(255) not null, category_uid bigint, primary key (uid))TYPE=InnoDB; +create table tl_laqa11_wizard_question (uid bigint not null auto_increment, cognitive_skill_uid bigint, title text not null, primary key (uid))TYPE=InnoDB; +alter table tl_laqa11_wizard_cognitive_skill add index FK3BA4132BCBB0DC8D (category_uid), add constraint FK3BA4132BCBB0DC8D foreign key (category_uid) references tl_laqa11_wizard_category (uid); +alter table tl_laqa11_wizard_question add index FKAF08A0C7EFF77FD4 (cognitive_skill_uid), add constraint FKAF08A0C7EFF77FD4 foreign key (cognitive_skill_uid) references tl_laqa11_wizard_cognitive_skill (uid); + +-- Inserting the required config item into the config table +-- Gmap API key is added here for shaun so the Gmap works there automatically for each build +INSERT INTO tl_laqa11_configuration ( + config_key, + config_value +) +VALUES( + "enableQaWizard", + "false" +); +SET FOREIGN_KEY_CHECKS=1; + +-- updating q&a to have an admin page for the qa wizard +UPDATE lams_tool SET admin_url='tool/laqa11/laqa11admin.do' WHERE tool_signature='laqa11';