Index: lams_tool_laqa/db/sql/create_lams_tool_qa.sql =================================================================== diff -u -r80a367726b9e7607851be28429bda54d9b306159 -r43e0381eea3a0c47164074f69d98cda915f8acff --- lams_tool_laqa/db/sql/create_lams_tool_qa.sql (.../create_lams_tool_qa.sql) (revision 80a367726b9e7607851be28429bda54d9b306159) +++ lams_tool_laqa/db/sql/create_lams_tool_qa.sql (.../create_lams_tool_qa.sql) (revision 43e0381eea3a0c47164074f69d98cda915f8acff) @@ -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 =================================================================== diff -u -r3c9498a300869406f94e733146524cb8f64269fb -r43e0381eea3a0c47164074f69d98cda915f8acff --- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20080926_updateFrom21.sql (.../patch20080926_updateFrom21.sql) (revision 3c9498a300869406f94e733146524cb8f64269fb) +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20080926_updateFrom21.sql (.../patch20080926_updateFrom21.sql) (revision 43e0381eea3a0c47164074f69d98cda915f8acff) @@ -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';