Index: lams_common/db/sql/create_notebook_tables.sql
===================================================================
diff -u -re141d26f7d22901831d0e3c0f3083e419c764c7d -r98f10c35c8f290b7f3bcea1908f22cd77e7e8943
--- lams_common/db/sql/create_notebook_tables.sql	(.../create_notebook_tables.sql)	(revision e141d26f7d22901831d0e3c0f3083e419c764c7d)
+++ lams_common/db/sql/create_notebook_tables.sql	(.../create_notebook_tables.sql)	(revision 98f10c35c8f290b7f3bcea1908f22cd77e7e8943)
@@ -1,2 +1,2 @@
 drop table if exists lams_notebook_entry;
-create table lams_notebook_entry (uid bigint not null auto_increment, external_id bigint, external_id_type integer, external_signature varchar(255), user_id integer, title varchar(255), entry text, create_date datetime, last_modified datetime, primary key (uid));
+create table lams_notebook_entry (uid bigint not null auto_increment, external_id bigint, external_id_type integer, external_signature varchar(255), user_id integer, title varchar(255), entry text, create_date datetime, last_modified datetime, primary key (uid))type=innodb;
Index: lams_common/db/sql/create_quartz_table.sql
===================================================================
diff -u -r7697bd6b1da52d525246c6b28a2508d167b32a47 -r98f10c35c8f290b7f3bcea1908f22cd77e7e8943
--- lams_common/db/sql/create_quartz_table.sql	(.../create_quartz_table.sql)	(revision 7697bd6b1da52d525246c6b28a2508d167b32a47)
+++ lams_common/db/sql/create_quartz_table.sql	(.../create_quartz_table.sql)	(revision 98f10c35c8f290b7f3bcea1908f22cd77e7e8943)
@@ -36,7 +36,7 @@
     REQUESTS_RECOVERY VARCHAR(1) NOT NULL,
     JOB_DATA BLOB NULL,
     PRIMARY KEY (JOB_NAME,JOB_GROUP)
-);
+)TYPE=InnoDB;
 
 CREATE TABLE lams_qtz_JOB_LISTENERS
   (
@@ -46,7 +46,7 @@
     PRIMARY KEY (JOB_NAME,JOB_GROUP,JOB_LISTENER),
     FOREIGN KEY (JOB_NAME,JOB_GROUP)
         REFERENCES lams_qtz_JOB_DETAILS(JOB_NAME,JOB_GROUP)
-);
+)TYPE=InnoDB;
 
 CREATE TABLE lams_qtz_TRIGGERS
   (
@@ -68,7 +68,7 @@
     PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
     FOREIGN KEY (JOB_NAME,JOB_GROUP)
         REFERENCES lams_qtz_JOB_DETAILS(JOB_NAME,JOB_GROUP)
-);
+)TYPE=InnoDB;
 
 CREATE TABLE lams_qtz_SIMPLE_TRIGGERS
   (
@@ -80,7 +80,7 @@
     PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
     FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
         REFERENCES lams_qtz_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
-);
+)TYPE=InnoDB;
 
 CREATE TABLE lams_qtz_CRON_TRIGGERS
   (
@@ -91,7 +91,7 @@
     PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
     FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
         REFERENCES lams_qtz_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
-);
+)TYPE=InnoDB;
 
 CREATE TABLE lams_qtz_BLOB_TRIGGERS
   (
@@ -101,7 +101,7 @@
     PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
     FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
         REFERENCES lams_qtz_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
-);
+)TYPE=InnoDB;
 
 CREATE TABLE lams_qtz_TRIGGER_LISTENERS
   (
@@ -111,23 +111,23 @@
     PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_LISTENER),
     FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
         REFERENCES lams_qtz_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
-);
+)TYPE=InnoDB;
 
 
 CREATE TABLE lams_qtz_CALENDARS
   (
     CALENDAR_NAME  VARCHAR(80) NOT NULL,
     CALENDAR BLOB NOT NULL,
     PRIMARY KEY (CALENDAR_NAME)
-);
+)TYPE=InnoDB;
 
 
 
 CREATE TABLE lams_qtz_PAUSED_TRIGGER_GRPS
   (
     TRIGGER_GROUP  VARCHAR(80) NOT NULL, 
     PRIMARY KEY (TRIGGER_GROUP)
-);
+)TYPE=InnoDB;
 
 CREATE TABLE lams_qtz_FIRED_TRIGGERS
   (
@@ -143,7 +143,7 @@
     IS_STATEFUL VARCHAR(1) NULL,
     REQUESTS_RECOVERY VARCHAR(1) NULL,
     PRIMARY KEY (ENTRY_ID)
-);
+)TYPE=InnoDB;
 
 CREATE TABLE lams_qtz_SCHEDULER_STATE
   (
@@ -152,13 +152,13 @@
     CHECKIN_INTERVAL BIGINT(13) NOT NULL,
     RECOVERER VARCHAR(80) NULL,
     PRIMARY KEY (INSTANCE_NAME)
-);
+)TYPE=InnoDB;
 
 CREATE TABLE lams_qtz_LOCKS
   (
     LOCK_NAME  VARCHAR(40) NOT NULL, 
     PRIMARY KEY (LOCK_NAME)
-);
+)TYPE=InnoDB;
 
 
 INSERT INTO lams_qtz_LOCKS values('TRIGGER_ACCESS');
Index: lams_common/db/sql/updatescripts/alter_21_engine.sql
===================================================================
diff -u
--- lams_common/db/sql/updatescripts/alter_21_engine.sql	(revision 0)
+++ lams_common/db/sql/updatescripts/alter_21_engine.sql	(revision 98f10c35c8f290b7f3bcea1908f22cd77e7e8943)
@@ -0,0 +1,15 @@
+-- LDEV-1511
+ALTER TABLE lams_configuration ENGINE=InnoDB;
+ALTER TABLE lams_notebook_entry ENGINE=InnoDB;
+ALTER TABLE lams_qtz_BLOB_TRIGGERS ENGINE=InnoDB;
+ALTER TABLE lams_qtz_CALENDARS ENGINE=InnoDB;
+ALTER TABLE lams_qtz_CRON_TRIGGERS ENGINE=InnoDB;
+ALTER TABLE lams_qtz_FIRED_TRIGGERS ENGINE=InnoDB;
+ALTER TABLE lams_qtz_JOB_DETAILS ENGINE=InnoDB;
+ALTER TABLE lams_qtz_JOB_LISTENERS ENGINE=InnoDB;
+ALTER TABLE lams_qtz_LOCKS ENGINE=InnoDB;
+ALTER TABLE lams_qtz_PAUSED_TRIGGER_GRPS ENGINE=InnoDB;
+ALTER TABLE lams_qtz_SCHEDULER_STATE ENGINE=InnoDB;
+ALTER TABLE lams_qtz_SIMPLE_TRIGGERS ENGINE=InnoDB;
+ALTER TABLE lams_qtz_TRIGGERS ENGINE=InnoDB;
+ALTER TABLE lams_qtz_TRIGGER_LISTENERS ENGINE=InnoDB;
Index: lams_tool_chat/db/sql/create_lams_tool_chat.sql
===================================================================
diff -u -r3a00494e8ecd90ce49d79927d74b4a6b96ba853a -r98f10c35c8f290b7f3bcea1908f22cd77e7e8943
--- lams_tool_chat/db/sql/create_lams_tool_chat.sql	(.../create_lams_tool_chat.sql)	(revision 3a00494e8ecd90ce49d79927d74b4a6b96ba853a)
+++ lams_tool_chat/db/sql/create_lams_tool_chat.sql	(.../create_lams_tool_chat.sql)	(revision 98f10c35c8f290b7f3bcea1908f22cd77e7e8943)
@@ -7,11 +7,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), room_created bit, 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), room_created bit, 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_chat/db/sql/updatescripts/updateTo20080229.sql
===================================================================
diff -u
--- lams_tool_chat/db/sql/updatescripts/updateTo20080229.sql	(revision 0)
+++ lams_tool_chat/db/sql/updatescripts/updateTo20080229.sql	(revision 98f10c35c8f290b7f3bcea1908f22cd77e7e8943)
@@ -0,0 +1,8 @@
+-- LDEV1511 make tables InnoDB
+ALTER TABLE tl_lachat11_attachment ENGINE=InnoDB;
+ALTER TABLE tl_lachat11_chat ENGINE=InnoDB;
+ALTER TABLE tl_lachat11_message ENGINE=InnoDB;
+ALTER TABLE tl_lachat11_session ENGINE=InnoDB;
+ALTER TABLE tl_lachat11_user ENGINE=InnoDB;
+UPDATE lams_tool SET modified_date_time = NOW() WHERE tool_signature = "lachat11";
+UPDATE lams_tool SET tool_version = "20080229" WHERE tool_signature = "lachat11";
\ No newline at end of file
Index: lams_tool_larsrc/db/sql/create_lams_tool_rsrc.sql
===================================================================
diff -u -r6603efa89f1b12ec24d88500d2cca192c9d30d6b -r98f10c35c8f290b7f3bcea1908f22cd77e7e8943
--- lams_tool_larsrc/db/sql/create_lams_tool_rsrc.sql	(.../create_lams_tool_rsrc.sql)	(revision 6603efa89f1b12ec24d88500d2cca192c9d30d6b)
+++ lams_tool_larsrc/db/sql/create_lams_tool_rsrc.sql	(.../create_lams_tool_rsrc.sql)	(revision 98f10c35c8f290b7f3bcea1908f22cd77e7e8943)
@@ -15,14 +15,14 @@
    create_date datetime,
    resource_uid bigint,
    primary key (uid)
-);
+)type=innodb;
 create table tl_larsrc11_item_instruction (
    uid bigint not null auto_increment,
    description varchar(255),
    sequence_id integer,
    item_uid bigint,
    primary key (uid)
-);
+)type=innodb;
 create table tl_larsrc11_resource (
    uid bigint not null auto_increment,
    create_date datetime,
@@ -44,7 +44,7 @@
    reflect_instructions varchar(255), 
    reflect_on_activity smallint, 
    primary key (uid)
-);
+)type=innodb;
 create table tl_larsrc11_resource_item (
    uid bigint not null auto_increment,
    file_uuid bigint,
@@ -66,7 +66,7 @@
    resource_uid bigint,
    session_uid bigint,
    primary key (uid)
-);
+)type=innodb;
 create table tl_larsrc11_item_log (
    uid bigint not null auto_increment,
    access_date datetime,
@@ -75,7 +75,7 @@
    complete tinyint,
    session_id bigint,
    primary key (uid)
-);
+)type=innodb;
 create table tl_larsrc11_session (
    uid bigint not null auto_increment,
    session_end_date datetime,
@@ -85,7 +85,7 @@
    session_id bigint,
    session_name varchar(250),
    primary key (uid)
-);
+)type=innodb;
 create table tl_larsrc11_user (
    uid bigint not null auto_increment,
    user_id bigint,
@@ -96,7 +96,7 @@
    session_uid bigint,
    resource_uid bigint,
    primary key (uid)
-);
+)type=innodb;
 alter table tl_larsrc11_attachment add index FK1E7009430E79035 (resource_uid), add constraint FK1E7009430E79035 foreign key (resource_uid) references tl_larsrc11_resource (uid);
 alter table tl_larsrc11_item_instruction add index FKA5665013980570ED (item_uid), add constraint FKA5665013980570ED foreign key (item_uid) references tl_larsrc11_resource_item (uid);
 alter table tl_larsrc11_resource add index FK89093BF758092FB (create_by), add constraint FK89093BF758092FB foreign key (create_by) references tl_larsrc11_user (uid);
Index: lams_tool_larsrc/db/sql/updatescripts/updateTo20080229.sql
===================================================================
diff -u
--- lams_tool_larsrc/db/sql/updatescripts/updateTo20080229.sql	(revision 0)
+++ lams_tool_larsrc/db/sql/updatescripts/updateTo20080229.sql	(revision 98f10c35c8f290b7f3bcea1908f22cd77e7e8943)
@@ -0,0 +1,10 @@
+-- LDEV1511 make tables InnoDB
+ALTER TABLE tl_larsrc11_attachment ENGINE=InnoDB;
+ALTER TABLE tl_larsrc11_item_instruction ENGINE=InnoDB;
+ALTER TABLE tl_larsrc11_item_log ENGINE=InnoDB;
+ALTER TABLE tl_larsrc11_resource ENGINE=InnoDB;
+ALTER TABLE tl_larsrc11_resource_item ENGINE=InnoDB;
+ALTER TABLE tl_larsrc11_session ENGINE=InnoDB;
+ALTER TABLE tl_larsrc11_user ENGINE=InnoDB;
+UPDATE lams_tool SET modified_date_time = NOW() WHERE tool_signature = "larsrc11";
+UPDATE lams_tool SET tool_version = "20080229" WHERE tool_signature = "larsrc11";
Index: lams_tool_notebook/db/sql/updatescripts/updateTo20080229.sql
===================================================================
diff -u
--- lams_tool_notebook/db/sql/updatescripts/updateTo20080229.sql	(revision 0)
+++ lams_tool_notebook/db/sql/updatescripts/updateTo20080229.sql	(revision 98f10c35c8f290b7f3bcea1908f22cd77e7e8943)
@@ -0,0 +1,7 @@
+-- LDEV1511 make tables InnoDB
+ALTER TABLE tl_lantbk11_attachment ENGINE=InnoDB;
+ALTER TABLE tl_lantbk11_notebook ENGINE=InnoDB;
+ALTER TABLE tl_lantbk11_session ENGINE=InnoDB;
+ALTER TABLE tl_lantbk11_user ENGINE=InnoDB;
+UPDATE lams_tool SET modified_date_time = NOW() WHERE tool_signature = "lantbk11";
+UPDATE lams_tool SET tool_version = "20080229" WHERE tool_signature = "lantbk11";
Index: lams_tool_scribe/db/sql/create_lams_tool_scribe.sql
===================================================================
diff -u -r0edacde89fb315c54ed60643a06ef7d3e7b5bb89 -r98f10c35c8f290b7f3bcea1908f22cd77e7e8943
--- lams_tool_scribe/db/sql/create_lams_tool_scribe.sql	(.../create_lams_tool_scribe.sql)	(revision 0edacde89fb315c54ed60643a06ef7d3e7b5bb89)
+++ lams_tool_scribe/db/sql/create_lams_tool_scribe.sql	(.../create_lams_tool_scribe.sql)	(revision 98f10c35c8f290b7f3bcea1908f22cd77e7e8943)
@@ -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));
-create table tl_lascrb11_heading (uid bigint not null auto_increment, heading text, scribe_uid bigint, display_order integer, primary key (uid));
-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));
-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));
-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));
-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));
+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;
 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_scribe/db/sql/updatescripts/updateTo20080229.sql
===================================================================
diff -u
--- lams_tool_scribe/db/sql/updatescripts/updateTo20080229.sql	(revision 0)
+++ lams_tool_scribe/db/sql/updatescripts/updateTo20080229.sql	(revision 98f10c35c8f290b7f3bcea1908f22cd77e7e8943)
@@ -0,0 +1,9 @@
+-- LDEV1511 make tables InnoDB
+ALTER TABLE tl_lascrb11_attachment ENGINE=InnoDB;
+ALTER TABLE tl_lascrb11_heading ENGINE=InnoDB;
+ALTER TABLE tl_lascrb11_report_entry ENGINE=InnoDB;
+ALTER TABLE tl_lascrb11_scribe ENGINE=InnoDB;
+ALTER TABLE tl_lascrb11_session ENGINE=InnoDB;
+ALTER TABLE tl_lascrb11_user ENGINE=InnoDB;
+UPDATE lams_tool SET modified_date_time = NOW() WHERE tool_signature = "lascrb11";
+UPDATE lams_tool SET tool_version = "20080229" WHERE tool_signature = "lascrb11";
Index: lams_tool_survey/db/sql/create_lams_tool_survey.sql
===================================================================
diff -u -r3ed8ec9b631a9c24c862da5c7067e4bcc5c33458 -r98f10c35c8f290b7f3bcea1908f22cd77e7e8943
--- lams_tool_survey/db/sql/create_lams_tool_survey.sql	(.../create_lams_tool_survey.sql)	(revision 3ed8ec9b631a9c24c862da5c7067e4bcc5c33458)
+++ lams_tool_survey/db/sql/create_lams_tool_survey.sql	(.../create_lams_tool_survey.sql)	(revision 98f10c35c8f290b7f3bcea1908f22cd77e7e8943)
@@ -26,7 +26,7 @@
 update_date datetime, 
 create_by bigint, 
 primary key (uid)
-);
+)type=innodb;
 
 
 create table tl_lasurv11_answer (
@@ -37,7 +37,7 @@
 udpate_date datetime, 
 answer_text text, 
 primary key (uid)
-);
+)type=innodb;
 
 create table tl_lasurv11_attachment (
 uid bigint not null auto_increment, 
@@ -48,15 +48,15 @@
 create_date datetime, 
 survey_uid bigint, 
 primary key (uid)
-);
+)type=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;
 
 create table tl_lasurv11_question (
 uid bigint not null auto_increment, 
@@ -70,7 +70,7 @@
 allow_multiple_answer smallint,
 survey_uid bigint, 
 primary key (uid)
-);
+)type=innodb;
 
 create table tl_lasurv11_session (
 uid bigint not null auto_increment, 
@@ -80,7 +80,7 @@
 session_id bigint, 
 session_name varchar(250), 
 primary key (uid)
-);
+)type=innodb;
 
 create table tl_lasurv11_user (
 uid bigint not null auto_increment, 
@@ -92,7 +92,7 @@
 survey_uid bigint, 
 session_finished smallint, 
 primary key (uid)
-);
+)type=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/db/sql/updatescripts/updateTo20080229.sql
===================================================================
diff -u
--- lams_tool_survey/db/sql/updatescripts/updateTo20080229.sql	(revision 0)
+++ lams_tool_survey/db/sql/updatescripts/updateTo20080229.sql	(revision 98f10c35c8f290b7f3bcea1908f22cd77e7e8943)
@@ -0,0 +1,10 @@
+-- LDEV1511 make tables InnoDB
+ALTER TABLE tl_lasurv11_answer ENGINE=InnoDB;
+ALTER TABLE tl_lasurv11_attachment ENGINE=InnoDB;
+ALTER TABLE tl_lasurv11_option ENGINE=InnoDB;
+ALTER TABLE tl_lasurv11_question ENGINE=InnoDB;
+ALTER TABLE tl_lasurv11_session ENGINE=InnoDB;
+ALTER TABLE tl_lasurv11_survey ENGINE=InnoDB;
+ALTER TABLE tl_lasurv11_user ENGINE=InnoDB;
+UPDATE lams_tool SET modified_date_time = NOW() WHERE tool_signature = "lasurv11";
+UPDATE lams_tool SET tool_version = "20080229" WHERE tool_signature = "lasurv11";