Index: lams_tool_chat/db/sql/create_lams_tool_chat.sql
===================================================================
diff -u -r4723715bee4472a5a41fc2cafd690b23b7ae4e2a -r62c0d1eb5c28094e0719349e883324f592807cd4
--- lams_tool_chat/db/sql/create_lams_tool_chat.sql	(.../create_lams_tool_chat.sql)	(revision 4723715bee4472a5a41fc2cafd690b23b7ae4e2a)
+++ lams_tool_chat/db/sql/create_lams_tool_chat.sql	(.../create_lams_tool_chat.sql)	(revision 62c0d1eb5c28094e0719349e883324f592807cd4)
@@ -6,11 +6,11 @@
 drop table if exists tl_lachat11_message;
 drop table if exists tl_lachat11_session;
 drop table if exists tl_lachat11_user;
-create table tl_lachat11_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, chat_uid bigint, primary key (uid));
-create table tl_lachat11_chat (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, reflect_on_activity bit, reflect_instructions text, online_instructions text, offline_instructions text, content_in_use bit, define_later bit, tool_content_id bigint, filtering_enabled bit, filter_keywords text, primary key (uid));
-create table tl_lachat11_message (uid bigint not null auto_increment, chat_session_uid bigint not null, from_user_uid bigint, to_user_uid bigint, type varchar(255), body text, send_date datetime, hidden bit, primary key (uid));
-create table tl_lachat11_session (uid bigint not null auto_increment, session_end_date datetime, session_start_date datetime, status integer, session_id bigint, session_name varchar(250), chat_uid bigint, jabber_room varchar(250), primary key (uid));
-create table tl_lachat11_user (uid bigint not null auto_increment, user_id bigint, last_name varchar(255), login_name varchar(255), first_name varchar(255), jabber_id varchar(255), finishedActivity bit, jabber_nickname varchar(255), chat_session_uid bigint, primary key (uid));
+create table tl_lachat11_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, chat_uid bigint, primary key (uid))TYPE=InnoDB;
+create table tl_lachat11_chat (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, reflect_on_activity bit, reflect_instructions text, online_instructions text, offline_instructions text, content_in_use bit, define_later bit, tool_content_id bigint, filtering_enabled bit, filter_keywords text, primary key (uid))TYPE=InnoDB;
+create table tl_lachat11_message (uid bigint not null auto_increment, chat_session_uid bigint not null, from_user_uid bigint, to_user_uid bigint, type varchar(255), body text, send_date datetime, hidden bit, primary key (uid))TYPE=InnoDB;
+create table tl_lachat11_session (uid bigint not null auto_increment, session_end_date datetime, session_start_date datetime, status integer, session_id bigint, session_name varchar(250), chat_uid bigint, jabber_room varchar(250), primary key (uid))TYPE=InnoDB;
+create table tl_lachat11_user (uid bigint not null auto_increment, user_id bigint, last_name varchar(255), login_name varchar(255), first_name varchar(255), jabber_id varchar(255), finishedActivity bit, jabber_nickname varchar(255), chat_session_uid bigint, primary key (uid))TYPE=InnoDB;
 alter table tl_lachat11_attachment add index FK9ED6CB2E1A3926E3 (chat_uid), add constraint FK9ED6CB2E1A3926E3 foreign key (chat_uid) references tl_lachat11_chat (uid);
 alter table tl_lachat11_message add index FKCC08C1DC2AF61E05 (to_user_uid), add constraint FKCC08C1DC2AF61E05 foreign key (to_user_uid) references tl_lachat11_user (uid);
 alter table tl_lachat11_message add index FKCC08C1DC9C8469FC (chat_session_uid), add constraint FKCC08C1DC9C8469FC foreign key (chat_session_uid) references tl_lachat11_session (uid);
Index: lams_tool_forum/db/sql/create_lams_tool_forum.sql
===================================================================
diff -u -r77e263b43c7aed360e8dcc46af273db55123bc83 -r62c0d1eb5c28094e0719349e883324f592807cd4
--- lams_tool_forum/db/sql/create_lams_tool_forum.sql	(.../create_lams_tool_forum.sql)	(revision 77e263b43c7aed360e8dcc46af273db55123bc83)
+++ lams_tool_forum/db/sql/create_lams_tool_forum.sql	(.../create_lams_tool_forum.sql)	(revision 62c0d1eb5c28094e0719349e883324f592807cd4)
@@ -18,7 +18,7 @@
    forum_uid bigint,
    message_uid bigint,
    primary key (uid)
-);
+)TYPE=InnoDB;
 create table tl_lafrum11_forum (
    uid bigint not null auto_increment,
    create_date datetime,
@@ -45,7 +45,7 @@
    reflect_instructions varchar(255),
    reflect_on_activity smallint, 
    primary key (uid)
-);
+)TYPE=InnoDB;
 create table tl_lafrum11_forum_user (
    uid bigint not null auto_increment,
    user_id bigint,
@@ -55,7 +55,7 @@
    login_name varchar(255),
    session_finished smallint,
    primary key (uid)
-);
+)TYPE=InnoDB;
 create table tl_lafrum11_message (
    uid bigint not null auto_increment,
    create_date datetime,
@@ -74,21 +74,21 @@
    hide_flag smallint,
    report_id bigint,
    primary key (uid)
-);
+)TYPE=InnoDB;
 create table tl_lafrum11_message_seq (
    uid bigint not null auto_increment,
    root_message_uid bigint,
    message_uid bigint,
    message_level smallint,
    primary key (uid)
-);
+)TYPE=InnoDB;
 create table tl_lafrum11_report (
    uid bigint not null auto_increment,
    comment text,
    release_date datetime,
    mark float,
    primary key (uid)
-);
+)TYPE=InnoDB;
 create table tl_lafrum11_tool_session (
    uid bigint not null auto_increment,
    session_end_date datetime,
@@ -99,7 +99,7 @@
    session_id bigint,
    session_name varchar(250),
    primary key (uid)
-);
+)TYPE=InnoDB;
 alter table tl_lafrum11_attachment add index FK389AD9A2FE939F2A (message_uid), add constraint FK389AD9A2FE939F2A foreign key (message_uid) references tl_lafrum11_message (uid);
 alter table tl_lafrum11_attachment add index FK389AD9A2131CE31E (forum_uid), add constraint FK389AD9A2131CE31E foreign key (forum_uid) references tl_lafrum11_forum (uid);
 alter table tl_lafrum11_forum add index FK87917942E42F4351 (create_by), add constraint FK87917942E42F4351 foreign key (create_by) references tl_lafrum11_forum_user (uid);
Index: lams_tool_sbmt/db/sql/create_lams_tool_sbmt.sql
===================================================================
diff -u -r843aa271bd7b90368cc12ce6547069eaedffa066 -r62c0d1eb5c28094e0719349e883324f592807cd4
--- lams_tool_sbmt/db/sql/create_lams_tool_sbmt.sql	(.../create_lams_tool_sbmt.sql)	(revision 843aa271bd7b90368cc12ce6547069eaedffa066)
+++ lams_tool_sbmt/db/sql/create_lams_tool_sbmt.sql	(.../create_lams_tool_sbmt.sql)	(revision 62c0d1eb5c28094e0719349e883324f592807cd4)
@@ -20,7 +20,7 @@
    reflect_instructions varchar(255), 
    reflect_on_activity smallint, 
    primary key (content_id)
-);
+)TYPE=InnoDB;
 create table tl_lasbmt11_instruction_files (
    uid bigint not null auto_increment,
    uuid bigint,
@@ -29,21 +29,21 @@
    name varchar(255),
    content_id bigint,
    primary key (uid)
-);
+)TYPE=InnoDB;
 create table tl_lasbmt11_report (
    report_id bigint not null auto_increment,
    comments varchar(250),
    marks bigint,
    date_marks_released datetime,
    primary key (report_id)
-);
+)TYPE=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;
 create table tl_lasbmt11_session_learners (
    learner_id bigint not null auto_increment,
    user_id bigint,
@@ -53,7 +53,7 @@
    login_name varchar(255), 
    last_name varchar(255), 
    primary key (learner_id)
-);
+)TYPE=InnoDB;
 create table tl_lasbmt11_submission_details (
    submission_id bigint not null auto_increment,
    filePath varchar(250),
@@ -64,7 +64,7 @@
    session_id bigint,
    learner_id bigint,
    primary key (submission_id)
-);
+)TYPE=InnoDB;
 alter table tl_lasbmt11_instruction_files add index FKA75538F9785A173A (content_id), add constraint FKA75538F9785A173A foreign key (content_id) references tl_lasbmt11_content (content_id);
 alter table tl_lasbmt11_session add index FKEC8C77C9785A173A (content_id), add constraint FKEC8C77C9785A173A foreign key (content_id) references tl_lasbmt11_content (content_id);
 alter table tl_lasbmt11_session_learners add index FKC56CD05893C861A (session_id), add constraint FKC56CD05893C861A foreign key (session_id) references tl_lasbmt11_session (session_id);