Index: lams_tool_sbmt/db/sql/create_lams_tool_sbmt.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_sbmt/db/sql/create_lams_tool_sbmt.sql,v diff -u -r1.31 -r1.32 --- lams_tool_sbmt/db/sql/create_lams_tool_sbmt.sql 12 Apr 2011 12:21:33 -0000 1.31 +++ lams_tool_sbmt/db/sql/create_lams_tool_sbmt.sql 19 Feb 2012 20:23:41 -0000 1.32 @@ -28,7 +28,7 @@ mark_release_notify tinyint DEFAULT 0, file_submit_notify tinyint DEFAULT 0, primary key (content_id) -)TYPE=InnoDB; +)ENGINE=InnoDB; create table tl_lasbmt11_user ( uid bigint not null auto_increment, user_id integer, @@ -39,7 +39,7 @@ last_name varchar(255), content_id bigint, primary key (uid) -)TYPE=InnoDB; +)ENGINE=InnoDB; create table tl_lasbmt11_instruction_files ( uid bigint not null auto_increment, @@ -49,7 +49,7 @@ name varchar(255), content_id bigint, primary key (uid) -)TYPE=InnoDB; +)ENGINE=InnoDB; create table tl_lasbmt11_report ( report_id bigint not null auto_increment, comments text, @@ -59,14 +59,14 @@ mark_file_version_id bigint, mark_file_name varchar(255), primary key (report_id) -)TYPE=InnoDB; +)ENGINE=InnoDB; create table tl_lasbmt11_session ( session_id bigint not null, status integer not null, content_id bigint, session_name varchar(250), primary key (session_id) -)TYPE=InnoDB; +)ENGINE=InnoDB; create table tl_lasbmt11_submission_details ( submission_id bigint not null auto_increment, filePath varchar(250), @@ -77,7 +77,7 @@ session_id bigint, learner_id bigint, primary key (submission_id) -)TYPE=InnoDB; +)ENGINE=InnoDB; alter table tl_lasbmt11_content add index FKAEF329AC172BC670 (created_by), add constraint FKAEF329AC172BC670 foreign key (created_by) references tl_lasbmt11_user (uid); alter table tl_lasbmt11_instruction_files add index FKA75538F9785A173A (content_id), add constraint FKA75538F9785A173A foreign key (content_id) references tl_lasbmt11_content (content_id); Index: lams_tool_scribe/db/sql/create_lams_tool_scribe.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_scribe/db/sql/create_lams_tool_scribe.sql,v diff -u -r1.11 -r1.12 --- lams_tool_scribe/db/sql/create_lams_tool_scribe.sql 29 Feb 2008 03:46:51 -0000 1.11 +++ lams_tool_scribe/db/sql/create_lams_tool_scribe.sql 19 Feb 2012 20:24:01 -0000 1.12 @@ -7,12 +7,12 @@ drop table if exists tl_lascrb11_scribe; drop table if exists tl_lascrb11_session; drop table if exists tl_lascrb11_user; -create table tl_lascrb11_attachment (uid bigint not null auto_increment, file_version_id bigint, file_type varchar(255), file_name varchar(255), file_uuid bigint, create_date datetime, scribe_uid bigint, primary key (uid))type=innodb; -create table tl_lascrb11_heading (uid bigint not null auto_increment, heading text, scribe_uid bigint, display_order integer, primary key (uid))type=innodb; -create table tl_lascrb11_report_entry (uid bigint not null auto_increment, entry_text text, scribe_heading_uid bigint, scribe_session_uid bigint, primary key (uid))type=innodb; -create table tl_lascrb11_scribe (uid bigint not null auto_increment, create_date datetime, update_date datetime, create_by bigint, title varchar(255), instructions text, run_offline bit, lock_on_finished bit, auto_select_scribe bit, reflect_on_activity bit, reflect_instructions text, online_instructions text, offline_instructions text, content_in_use bit, define_later bit, tool_content_id bigint, aggregated_reports bit default 0, primary key (uid))type=innodb; -create table tl_lascrb11_session (uid bigint not null auto_increment, version integer not null, session_end_date datetime, session_start_date datetime, status integer, session_id bigint, session_name varchar(250), scribe_uid bigint, appointed_scribe_uid bigint, force_complete bit, report_submitted bit, primary key (uid))type=innodb; -create table tl_lascrb11_user (uid bigint not null auto_increment, user_id bigint, last_name varchar(255), login_name varchar(255), first_name varchar(255), finishedActivity bit, scribe_session_uid bigint, report_approved bit, started_activity bit, primary key (uid))type=innodb; +create table tl_lascrb11_attachment (uid bigint not null auto_increment, file_version_id bigint, file_type varchar(255), file_name varchar(255), file_uuid bigint, create_date datetime, scribe_uid bigint, primary key (uid))ENGINE=InnoDB; +create table tl_lascrb11_heading (uid bigint not null auto_increment, heading text, scribe_uid bigint, display_order integer, primary key (uid))ENGINE=InnoDB; +create table tl_lascrb11_report_entry (uid bigint not null auto_increment, entry_text text, scribe_heading_uid bigint, scribe_session_uid bigint, primary key (uid))ENGINE=InnoDB; +create table tl_lascrb11_scribe (uid bigint not null auto_increment, create_date datetime, update_date datetime, create_by bigint, title varchar(255), instructions text, run_offline bit, lock_on_finished bit, auto_select_scribe bit, reflect_on_activity bit, reflect_instructions text, online_instructions text, offline_instructions text, content_in_use bit, define_later bit, tool_content_id bigint, aggregated_reports bit default 0, primary key (uid))ENGINE=InnoDB; +create table tl_lascrb11_session (uid bigint not null auto_increment, version integer not null, session_end_date datetime, session_start_date datetime, status integer, session_id bigint, session_name varchar(250), scribe_uid bigint, appointed_scribe_uid bigint, force_complete bit, report_submitted bit, primary key (uid))ENGINE=InnoDB; +create table tl_lascrb11_user (uid bigint not null auto_increment, user_id bigint, last_name varchar(255), login_name varchar(255), first_name varchar(255), finishedActivity bit, scribe_session_uid bigint, report_approved bit, started_activity bit, primary key (uid))ENGINE=InnoDB; alter table tl_lascrb11_attachment add index FK57953706B3FA1495 (scribe_uid), add constraint FK57953706B3FA1495 foreign key (scribe_uid) references tl_lascrb11_scribe (uid); alter table tl_lascrb11_heading add index FK428A22FFB3FA1495 (scribe_uid), add constraint FK428A22FFB3FA1495 foreign key (scribe_uid) references tl_lascrb11_scribe (uid); alter table tl_lascrb11_report_entry add index FK5439FACAEA50D086 (scribe_heading_uid), add constraint FK5439FACAEA50D086 foreign key (scribe_heading_uid) references tl_lascrb11_heading (uid); Index: lams_tool_spreadsheet/db/sql/create_lams_tool_spreadsheet.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_spreadsheet/db/sql/create_lams_tool_spreadsheet.sql,v diff -u -r1.2 -r1.3 --- lams_tool_spreadsheet/db/sql/create_lams_tool_spreadsheet.sql 11 Jul 2008 08:19:58 -0000 1.2 +++ lams_tool_spreadsheet/db/sql/create_lams_tool_spreadsheet.sql 19 Feb 2012 20:24:17 -0000 1.3 @@ -13,7 +13,7 @@ create_date datetime, spreadsheet_uid bigint, primary key (uid) -)type=innodb; +)ENGINE=InnoDB; create table tl_lasprd10_spreadsheet ( uid bigint not null auto_increment, create_date datetime, @@ -34,20 +34,20 @@ reflect_instructions varchar(255), reflect_on_activity smallint, primary key (uid) -)type=innodb; +)ENGINE=InnoDB; create table tl_lasprd10_user_modified_spreadsheet ( uid bigint not null auto_increment, user_modified_spreadsheet text, mark_id bigint, primary key (uid) -)type=innodb; +)ENGINE=InnoDB; create table tl_lasprd10_spreadsheet_mark ( uid bigint not null auto_increment, marks varchar(255), comments text, date_marks_released datetime, primary key (uid) -)type=innodb; +)ENGINE=InnoDB; create table tl_lasprd10_session ( uid bigint not null auto_increment, session_end_date datetime, @@ -57,7 +57,7 @@ session_id bigint, session_name varchar(250), primary key (uid) -)type=innodb; +)ENGINE=InnoDB; create table tl_lasprd10_user ( uid bigint not null auto_increment, user_id bigint, @@ -69,7 +69,7 @@ spreadsheet_uid bigint, user_modified_spreadsheet_uid bigint, primary key (uid) -)type=innodb; +)ENGINE=InnoDB; alter table tl_lasprd10_attachment add index FK_NEW_2065267438_1E7009430E79035 (spreadsheet_uid), add constraint FK_NEW_2065267438_1E7009430E79035 foreign key (spreadsheet_uid) references tl_lasprd10_spreadsheet (uid); alter table tl_lasprd10_spreadsheet add index FK_NEW_2065267438_89093BF758092FB (create_by), add constraint FK_NEW_2065267438_89093BF758092FB foreign key (create_by) references tl_lasprd10_user (uid); alter table tl_lasprd10_session add index FK_NEW_2065267438_24AA78C530E79035 (spreadsheet_uid), add constraint FK_NEW_2065267438_24AA78C530E79035 foreign key (spreadsheet_uid) references tl_lasprd10_spreadsheet (uid); Index: lams_tool_survey/db/sql/create_lams_tool_survey.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_survey/db/sql/create_lams_tool_survey.sql,v diff -u -r1.13 -r1.14 --- lams_tool_survey/db/sql/create_lams_tool_survey.sql 10 May 2011 11:51:21 -0000 1.13 +++ lams_tool_survey/db/sql/create_lams_tool_survey.sql 19 Feb 2012 20:24:32 -0000 1.14 @@ -28,7 +28,7 @@ create_by bigint, answer_submit_notify tinyint DEFAULT 0, primary key (uid) -)type=innodb; +)ENGINE=InnoDB; create table tl_lasurv11_answer ( @@ -39,7 +39,7 @@ udpate_date datetime, answer_text text, primary key (uid) -)type=innodb; +)ENGINE=InnoDB; create table tl_lasurv11_attachment ( uid bigint not null auto_increment, @@ -50,15 +50,15 @@ create_date datetime, survey_uid bigint, primary key (uid) -)type=innodb; +)ENGINE=InnoDB; create table tl_lasurv11_option ( uid bigint not null auto_increment, description text, sequence_id integer, question_uid bigint, primary key (uid) -)type=innodb; +)ENGINE=InnoDB; create table tl_lasurv11_question ( uid bigint not null auto_increment, @@ -72,7 +72,7 @@ allow_multiple_answer smallint, survey_uid bigint, primary key (uid) -)type=innodb; +)ENGINE=InnoDB; create table tl_lasurv11_session ( uid bigint not null auto_increment, @@ -82,7 +82,7 @@ session_id bigint, session_name varchar(250), primary key (uid) -)type=innodb; +)ENGINE=InnoDB; create table tl_lasurv11_user ( uid bigint not null auto_increment, @@ -94,7 +94,7 @@ survey_uid bigint, session_finished smallint, primary key (uid) -)type=innodb; +)ENGINE=InnoDB; CREATE TABLE tl_lasurv11_conditions ( condition_id BIGINT(20) NOT NULL @@ -104,7 +104,7 @@ REFERENCES lams_branch_condition(condition_id) ON DELETE CASCADE ON UPDATE CASCADE , CONSTRAINT SurveyConditionToSurvey FOREIGN KEY (content_uid) REFERENCES tl_lasurv11_survey(uid) ON DELETE CASCADE ON UPDATE CASCADE -)TYPE=InnoDB; +)ENGINE=InnoDB; CREATE TABLE tl_lasurv11_condition_questions ( condition_id BIGINT(20) @@ -114,7 +114,7 @@ REFERENCES tl_lasurv11_conditions(condition_id) ON DELETE CASCADE ON UPDATE CASCADE , CONSTRAINT SurveyConditionQuestionToSurveyQuestion FOREIGN KEY (question_uid) REFERENCES tl_lasurv11_question(uid) ON DELETE CASCADE ON UPDATE CASCADE -)TYPE=InnoDB; +)ENGINE=InnoDB; alter table tl_lasurv11_answer add index FK6DAAFE3BB1423DC1 (user_uid), add constraint FK6DAAFE3BB1423DC1 foreign key (user_uid) references tl_lasurv11_user (uid); alter table tl_lasurv11_answer add index FK6DAAFE3B25F3BB77 (question_uid), add constraint FK6DAAFE3B25F3BB77 foreign key (question_uid) references tl_lasurv11_question (uid); Index: lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20081021_updateFrom21.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20081021_updateFrom21.sql,v diff -u -r1.4 -r1.5 --- lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20081021_updateFrom21.sql 7 Jul 2009 00:34:48 -0000 1.4 +++ lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20081021_updateFrom21.sql 19 Feb 2012 20:24:32 -0000 1.5 @@ -13,7 +13,7 @@ REFERENCES lams_branch_condition(condition_id) ON DELETE CASCADE ON UPDATE CASCADE , CONSTRAINT SurveyConditionToSurvey FOREIGN KEY (content_uid) REFERENCES tl_lasurv11_survey(uid) ON DELETE CASCADE ON UPDATE CASCADE -)TYPE=InnoDB; +)ENGINE=InnoDB; CREATE TABLE tl_lasurv11_condition_questions ( condition_id BIGINT(20) @@ -23,7 +23,7 @@ REFERENCES tl_lasurv11_conditions(condition_id) ON DELETE CASCADE ON UPDATE CASCADE , CONSTRAINT SurveyConditionQuestionToSurveyQuestion FOREIGN KEY (question_uid) REFERENCES tl_lasurv11_question(uid) ON DELETE CASCADE ON UPDATE CASCADE -)TYPE=InnoDB; +)ENGINE=InnoDB; UPDATE lams_tool SET supports_outputs=1 WHERE tool_signature='lasurv11'; Index: lams_tool_task/db/sql/create_lams_tool_taskList.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_task/db/sql/create_lams_tool_taskList.sql,v diff -u -r1.16 -r1.17 --- lams_tool_task/db/sql/create_lams_tool_taskList.sql 10 May 2011 23:45:57 -0000 1.16 +++ lams_tool_task/db/sql/create_lams_tool_taskList.sql 19 Feb 2012 20:24:51 -0000 1.17 @@ -18,19 +18,19 @@ create_date datetime, taskList_uid bigint, primary key (uid) -)TYPE=InnoDB; +)ENGINE=InnoDB; create table tl_latask10_condition ( condition_uid bigint not null auto_increment, sequence_id integer, taskList_uid bigint, name varchar(255), primary key (condition_uid) -)TYPE=InnoDB; +)ENGINE=InnoDB; create table tl_latask10_condition_tl_item ( uid bigint not null, condition_uid bigint not null, primary key (uid, condition_uid) -)TYPE=InnoDB; +)ENGINE=InnoDB; create table tl_latask10_taskList ( uid bigint not null auto_increment, create_date datetime, @@ -53,7 +53,7 @@ reflect_on_activity smallint, submission_deadline datetime DEFAULT NULL, primary key (uid) -)TYPE=InnoDB; +)ENGINE=InnoDB; create table tl_latask10_taskList_item ( uid bigint not null auto_increment, sequence_id integer, @@ -76,7 +76,7 @@ taskList_uid bigint, session_uid bigint, primary key (uid) -)TYPE=InnoDB; +)ENGINE=InnoDB; create table tl_latask10_item_log ( uid bigint not null auto_increment, access_date datetime, @@ -85,7 +85,7 @@ complete tinyint, session_id bigint, primary key (uid) -)TYPE=InnoDB; +)ENGINE=InnoDB; create table tl_latask10_item_attachment ( uid bigint not null auto_increment, file_version_id bigint, @@ -96,15 +96,15 @@ taskList_item_uid bigint, create_by bigint, primary key (uid) -)TYPE=InnoDB; +)ENGINE=InnoDB; create table tl_latask10_item_comment ( uid bigint not null auto_increment, comment text, taskList_item_uid bigint, create_by bigint, create_date datetime, primary key (uid) -)TYPE=InnoDB; +)ENGINE=InnoDB; create table tl_latask10_session ( uid bigint not null auto_increment, session_end_date datetime, @@ -114,7 +114,7 @@ session_id bigint, session_name varchar(250), primary key (uid) -)TYPE=InnoDB; +)ENGINE=InnoDB; create table tl_latask10_user ( uid bigint not null auto_increment, user_id bigint, @@ -126,7 +126,7 @@ taskList_uid bigint, is_verified_by_monitor tinyint, primary key (uid) -)TYPE=InnoDB; +)ENGINE=InnoDB; alter table tl_latask10_attachment add index FK_NEW_174079138_1E7009430E79035 (taskList_uid), add constraint FK_NEW_174079138_1E7009430E79035 foreign key (taskList_uid) references tl_latask10_taskList (uid); alter table tl_latask10_condition add index FK_tl_latask10_condition_1 (taskList_uid), add constraint FK_tl_latask10_condition_1 foreign key (taskList_uid) references tl_latask10_taskList (uid); alter table tl_latask10_condition_tl_item add index FK_tl_latask10_taskList_item_condition_1 (condition_uid), add constraint FK_tl_latask10_taskList_item_condition_1 foreign key (condition_uid) references tl_latask10_condition (condition_uid); Index: lams_tool_videorecorder/db/sql/create_lams_tool_videoRecorder.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_videorecorder/db/sql/create_lams_tool_videoRecorder.sql,v diff -u -r1.5 -r1.6 --- lams_tool_videorecorder/db/sql/create_lams_tool_videoRecorder.sql 7 May 2009 06:15:46 -0000 1.5 +++ lams_tool_videorecorder/db/sql/create_lams_tool_videoRecorder.sql 19 Feb 2012 20:25:10 -0000 1.6 @@ -19,7 +19,7 @@ create_date datetime, videoRecorder_uid bigint, primary key (uid) -)type=innodb; +)ENGINE=InnoDB; create table tl_lavidr10_videoRecorder ( uid bigint not null auto_increment, @@ -47,7 +47,7 @@ export_offline bit, export_all bit, primary key (uid) -)type=innodb; +)ENGINE=InnoDB; create table tl_lavidr10_session ( uid bigint not null auto_increment, @@ -58,7 +58,7 @@ videoRecorder_uid bigint, content_folder_id varchar(32), primary key (uid) -)type=innodb; +)ENGINE=InnoDB; create table tl_lavidr10_recording ( uid bigint not null auto_increment, @@ -74,7 +74,7 @@ is_just_sound bit, videoRecorder_session_uid bigint, primary key (uid) -)type=innodb; +)ENGINE=InnoDB; create table tl_lavidr10_user ( uid bigint not null auto_increment, @@ -85,7 +85,7 @@ videoRecorder_session_uid bigint, entry_uid bigint, primary key (uid) -)type=innodb; +)ENGINE=InnoDB; create table tl_lavidr10_comment ( uid bigint not null auto_increment, @@ -95,7 +95,7 @@ create_by bigint, create_date datetime, primary key (uid) -)TYPE=InnoDB; +)ENGINE=InnoDB; create table tl_lavidr10_rating ( uid bigint not null auto_increment, @@ -105,7 +105,7 @@ create_by bigint, create_date datetime, primary key (uid) -)TYPE=InnoDB; +)ENGINE=InnoDB; alter table tl_lavidr10_attachment add index FK_NEW_75587508_12090F57FC940906 (videoRecorder_uid), add constraint FK_NEW_75587508_12090F57FC940906 foreign key (videoRecorder_uid) references tl_lavidr10_videoRecorder (uid); alter table tl_lavidr10_session add index FK_NEW_75587508_B7C198E2FC940906 (videoRecorder_uid), add constraint FK_NEW_75587508_B7C198E2FC940906 foreign key (videoRecorder_uid) references tl_lavidr10_videoRecorder (uid); @@ -161,6 +161,6 @@ REFERENCES lams_branch_condition(condition_id) ON DELETE CASCADE ON UPDATE CASCADE , CONSTRAINT VideoRecorderConditionToVideoRecorder FOREIGN KEY (content_uid) REFERENCES tl_lavidr10_videoRecorder(uid) ON DELETE CASCADE ON UPDATE CASCADE -)TYPE=InnoDB; +)ENGINE=InnoDB; SET FOREIGN_KEY_CHECKS=1; Index: lams_tool_vote/db/sql/create_lams_tool_vote.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_vote/db/sql/create_lams_tool_vote.sql,v diff -u -r1.30 -r1.31 --- lams_tool_vote/db/sql/create_lams_tool_vote.sql 17 May 2011 03:39:31 -0000 1.30 +++ lams_tool_vote/db/sql/create_lams_tool_vote.sql 19 Feb 2012 20:25:30 -0000 1.31 @@ -24,7 +24,7 @@ , max_external_inputs SMALLINT , submission_deadline datetime DEFAULT NULL , PRIMARY KEY (uid) -)TYPE=InnoDB; +)ENGINE=InnoDB; CREATE TABLE tl_lavote11_session ( uid BIGINT(20) NOT NULL AUTO_INCREMENT @@ -39,7 +39,7 @@ , INDEX (vote_content_id) , CONSTRAINT FK_tl_lavote11_session_1 FOREIGN KEY (vote_content_id) REFERENCES tl_lavote11_content (uid) -)TYPE=InnoDB; +)ENGINE=InnoDB; CREATE TABLE tl_lavote11_usr ( uid BIGINT(20) NOT NULL AUTO_INCREMENT @@ -53,7 +53,7 @@ , INDEX (vote_session_id) , CONSTRAINT FK_tl_lavote11_usr_1 FOREIGN KEY (vote_session_id) REFERENCES tl_lavote11_session (uid) -)TYPE=InnoDB; +)ENGINE=InnoDB; CREATE TABLE tl_lavote11_nomination_content ( uid BIGINT(20) NOT NULL AUTO_INCREMENT @@ -64,7 +64,7 @@ , INDEX (vote_content_id) , CONSTRAINT FK_tl_lavote11_nomination_content_1 FOREIGN KEY (vote_content_id) REFERENCES tl_lavote11_content (uid) -)TYPE=InnoDB; +)ENGINE=InnoDB; CREATE TABLE tl_lavote11_usr_attempt ( uid BIGINT(20) NOT NULL AUTO_INCREMENT @@ -82,7 +82,7 @@ , INDEX (vote_nomination_content_id) , CONSTRAINT FK_tl_lavote11_usr_attempt_3 FOREIGN KEY (vote_nomination_content_id) REFERENCES tl_lavote11_nomination_content (uid) -)TYPE=InnoDB; +)ENGINE=InnoDB; CREATE TABLE tl_lavote11_uploadedfile ( submissionId BIGINT(20) NOT NULL AUTO_INCREMENT @@ -94,7 +94,7 @@ , INDEX (vote_content_id) , CONSTRAINT FK_tablex_111 FOREIGN KEY (vote_content_id) REFERENCES tl_lavote11_content (uid) -)TYPE=InnoDB; +)ENGINE=InnoDB; INSERT INTO tl_lavote11_content(uid, content_id , title , instructions , creation_date , created_by , run_offline , define_later, offline_instructions, online_instructions, content_in_use, retries, lock_on_finish) VALUES (1, ${default_content_id} ,'Voting','Instructions', NOW(), 1,0, 0, '','', 0, 0, 0); Index: lams_tool_wiki/db/sql/create_lams_tool_wiki.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_wiki/db/sql/create_lams_tool_wiki.sql,v diff -u -r1.9 -r1.10 --- lams_tool_wiki/db/sql/create_lams_tool_wiki.sql 2 Jul 2009 08:19:20 -0000 1.9 +++ lams_tool_wiki/db/sql/create_lams_tool_wiki.sql 19 Feb 2012 20:25:46 -0000 1.10 @@ -7,10 +7,10 @@ drop table if exists tl_lawiki10_wiki; drop table if exists tl_lawiki10_wiki_page; drop table if exists tl_lawiki10_wiki_page_content; -create table tl_lawiki10_attachment (uid bigint not null auto_increment, file_version_id bigint, file_type varchar(255), file_name varchar(255), file_uuid bigint, create_date datetime, wiki_uid bigint, primary key (uid))TYPE=InnoDB; -create table tl_lawiki10_session (uid bigint not null auto_increment, session_end_date datetime, session_start_date datetime, status integer, session_id bigint, session_name varchar(250), wiki_uid bigint, wiki_main_page_uid bigint, content_folder_id varchar(255), primary key (uid))TYPE=InnoDB; -create table tl_lawiki10_user (uid bigint not null auto_increment, user_id bigint, last_name varchar(255), login_name varchar(255), first_name varchar(255), finishedActivity bit, wiki_session_uid bigint, entry_uid bigint, wiki_edits integer, primary key (uid))TYPE=InnoDB; -create table tl_lawiki10_wiki (uid bigint not null auto_increment, create_date datetime, update_date datetime, create_by bigint, title varchar(255), instructions text, run_offline bit, lock_on_finished bit, allow_learner_create_pages bit, allow_learner_insert_links bit, allow_learner_attach_images bit, notify_updates bit, reflect_on_activity bit, reflect_instructions text, minimum_edits integer, maximum_edits integer, online_instructions text, offline_instructions text, content_in_use bit, define_later bit, tool_content_id bigint, wiki_main_page_uid bigint, primary key (uid))TYPE=InnoDB; +create table tl_lawiki10_attachment (uid bigint not null auto_increment, file_version_id bigint, file_type varchar(255), file_name varchar(255), file_uuid bigint, create_date datetime, wiki_uid bigint, primary key (uid))ENGINE=InnoDB; +create table tl_lawiki10_session (uid bigint not null auto_increment, session_end_date datetime, session_start_date datetime, status integer, session_id bigint, session_name varchar(250), wiki_uid bigint, wiki_main_page_uid bigint, content_folder_id varchar(255), primary key (uid))ENGINE=InnoDB; +create table tl_lawiki10_user (uid bigint not null auto_increment, user_id bigint, last_name varchar(255), login_name varchar(255), first_name varchar(255), finishedActivity bit, wiki_session_uid bigint, entry_uid bigint, wiki_edits integer, primary key (uid))ENGINE=InnoDB; +create table tl_lawiki10_wiki (uid bigint not null auto_increment, create_date datetime, update_date datetime, create_by bigint, title varchar(255), instructions text, run_offline bit, lock_on_finished bit, allow_learner_create_pages bit, allow_learner_insert_links bit, allow_learner_attach_images bit, notify_updates bit, reflect_on_activity bit, reflect_instructions text, minimum_edits integer, maximum_edits integer, online_instructions text, offline_instructions text, content_in_use bit, define_later bit, tool_content_id bigint, wiki_main_page_uid bigint, primary key (uid))ENGINE=InnoDB; create table tl_lawiki10_wiki_page ( uid bigint not null auto_increment, wiki_uid bigint, @@ -21,9 +21,9 @@ wiki_session_uid bigint, primary key (uid), unique key wiki_unique_key (wiki_uid, title, wiki_session_uid) -)TYPE=InnoDB; +)ENGINE=InnoDB; -create table tl_lawiki10_wiki_page_content (uid bigint not null auto_increment, wiki_page_uid bigint, body text, editor bigint, edit_date datetime, version bigint, primary key (uid))TYPE=InnoDB; +create table tl_lawiki10_wiki_page_content (uid bigint not null auto_increment, wiki_page_uid bigint, body text, editor bigint, edit_date datetime, version bigint, primary key (uid))ENGINE=InnoDB; Index: lams_tool_wiki/src/java/org/lamsfoundation/lams/tool/wiki/dbupdates/patch20090121_updateFrom22.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_wiki/src/java/org/lamsfoundation/lams/tool/wiki/dbupdates/patch20090121_updateFrom22.sql,v diff -u -r1.4 -r1.5 --- lams_tool_wiki/src/java/org/lamsfoundation/lams/tool/wiki/dbupdates/patch20090121_updateFrom22.sql 7 Jul 2009 00:32:13 -0000 1.4 +++ lams_tool_wiki/src/java/org/lamsfoundation/lams/tool/wiki/dbupdates/patch20090121_updateFrom22.sql 19 Feb 2012 20:25:46 -0000 1.5 @@ -19,7 +19,7 @@ wiki_session_uid bigint, primary key (uid), unique key wiki_unique_key (wiki_uid, title, wiki_session_uid) -)TYPE=InnoDB; +)ENGINE=InnoDB; INSERT INTO tl_lawiki10_wiki_page_temp SELECT * from tl_lawiki10_wiki_page; drop table if exists tl_lawiki10_wiki_page; Index: lams_tool_wookie/db/sql/create_lams_tool_wookie.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_wookie/db/sql/create_lams_tool_wookie.sql,v diff -u -r1.4 -r1.5 --- lams_tool_wookie/db/sql/create_lams_tool_wookie.sql 7 Aug 2009 03:08:00 -0000 1.4 +++ lams_tool_wookie/db/sql/create_lams_tool_wookie.sql 19 Feb 2012 20:26:05 -0000 1.5 @@ -15,7 +15,7 @@ create_date datetime, wookie_uid bigint, primary key (uid) -)TYPE=InnoDB; +)ENGINE=InnoDB; create table tl_lawook10_wookie ( uid bigint not null auto_increment, @@ -39,7 +39,7 @@ widget_width integer, widget_height integer, primary key (uid) -)TYPE=InnoDB; +)ENGINE=InnoDB; create table tl_lawook10_session ( uid bigint not null auto_increment, @@ -55,7 +55,7 @@ widget_maximise bit, widget_identifier varchar(511), primary key (uid) -)TYPE=InnoDB; +)ENGINE=InnoDB; create table tl_lawook10_user ( uid bigint not null auto_increment, @@ -68,13 +68,13 @@ entry_uid bigint, user_widget_url varchar(511), primary key (uid) -)TYPE=InnoDB; +)ENGINE=InnoDB; create table tl_lawook10_configuration ( uid bigint not null auto_increment, config_key varchar(30) unique, config_value text, primary key (uid) -)TYPE=InnoDB; +)ENGINE=InnoDB; alter table tl_lawook10_attachment add index IN_WOOKIE_ATTACH (wookie_uid), add constraint FK_WOOKIE_ATTACH foreign key (wookie_uid) references tl_lawook10_wookie (uid); alter table tl_lawook10_session add index IN_WOOKIE_SESSION (wookie_uid), add constraint FK_WOOKIE_SESSION foreign key (wookie_uid) references tl_lawook10_wookie (uid);