Index: lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20081027_updateFrom21.sql
===================================================================
diff -u -rcd0d0b28a7c27711a74ce2b41821f3ccf5c80df9 -r667583f574672f48a6777c6d3e7e0f6b7a06d3f7
--- lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20081027_updateFrom21.sql	(.../patch20081027_updateFrom21.sql)	(revision cd0d0b28a7c27711a74ce2b41821f3ccf5c80df9)
+++ lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20081027_updateFrom21.sql	(.../patch20081027_updateFrom21.sql)	(revision 667583f574672f48a6777c6d3e7e0f6b7a06d3f7)
@@ -1,3 +1,9 @@
+
+-- Turn off autocommit, so nothing is committed if there is an error
+SET AUTOCOMMIT = 0;
+
+----------------------Put all sql statements below here-------------------------
+
 -- SQL statements to update from LAMS 2.1/2.1.1
 CREATE TABLE tl_lachat11_conditions (
        condition_id BIGINT(20) NOT NULL
@@ -9,4 +15,10 @@
                   REFERENCES tl_lachat11_chat(uid) ON DELETE CASCADE ON UPDATE CASCADE
 )TYPE=InnoDB;
 
-UPDATE lams_tool SET supports_outputs=1 WHERE tool_signature='lachat11';
\ No newline at end of file
+UPDATE lams_tool SET supports_outputs=1 WHERE tool_signature='lachat11';
+
+----------------------Put all sql statements above here-------------------------
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
\ No newline at end of file
Index: lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20081022_updateFrom21.sql
===================================================================
diff -u -rc081e2b0c9c82fc97d2d39fb7109c9c2f10ff224 -r667583f574672f48a6777c6d3e7e0f6b7a06d3f7
--- lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20081022_updateFrom21.sql	(.../patch20081022_updateFrom21.sql)	(revision c081e2b0c9c82fc97d2d39fb7109c9c2f10ff224)
+++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20081022_updateFrom21.sql	(.../patch20081022_updateFrom21.sql)	(revision 667583f574672f48a6777c6d3e7e0f6b7a06d3f7)
@@ -1,5 +1,10 @@
 -- SQL statements to update from LAMS 2.1/2.1.1
 
+-- Turn off autocommit, so nothing is committed if there is an error
+SET AUTOCOMMIT = 0;
+
+----------------------Put all sql statements below here-------------------------
+
 CREATE TABLE tl_lafrum11_conditions (
        condition_id BIGINT(20) NOT NULL
 	 , content_uid BIGINT(20)
@@ -18,4 +23,10 @@
                   REFERENCES tl_lafrum11_conditions(condition_id) ON DELETE CASCADE ON UPDATE CASCADE
 	 , CONSTRAINT ForumConditionQuestionToForumQuestion FOREIGN KEY (topic_uid)
                   REFERENCES tl_lafrum11_message(uid) ON DELETE CASCADE ON UPDATE CASCADE	
-)TYPE=InnoDB;
\ No newline at end of file
+)TYPE=InnoDB;
+
+----------------------Put all sql statements above here-------------------------
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
\ No newline at end of file
Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20080926_updateFrom21.sql
===================================================================
diff -u -r0e901d31073e341161c6d44143e026391dd84da0 -r667583f574672f48a6777c6d3e7e0f6b7a06d3f7
--- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20080926_updateFrom21.sql	(.../patch20080926_updateFrom21.sql)	(revision 0e901d31073e341161c6d44143e026391dd84da0)
+++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20080926_updateFrom21.sql	(.../patch20080926_updateFrom21.sql)	(revision 667583f574672f48a6777c6d3e7e0f6b7a06d3f7)
@@ -1,4 +1,12 @@
 -- SQL statements to update from LAMS 2.1/2.1.1
+
+-- Turn off autocommit, so nothing is committed if there is an error
+SET AUTOCOMMIT = 0;
+
+----------------------Put all sql statements below here-------------------------
+
+
+-- SQL statements to update from LAMS 2.1/2.1.1
 CREATE TABLE tl_laqa11_conditions (
        condition_id BIGINT(20) NOT NULL
 	 , content_uid BIGINT(20)
@@ -25,11 +33,8 @@
 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;
@@ -50,3 +55,10 @@
 
 -- 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';
+
+
+----------------------Put all sql statements above here-------------------------
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
Index: lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20080929_updateFrom21.sql
===================================================================
diff -u -ra74ae929e1b5f6e321e7251fb5bf5f93285c5b92 -r667583f574672f48a6777c6d3e7e0f6b7a06d3f7
--- lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20080929_updateFrom21.sql	(.../patch20080929_updateFrom21.sql)	(revision a74ae929e1b5f6e321e7251fb5bf5f93285c5b92)
+++ lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20080929_updateFrom21.sql	(.../patch20080929_updateFrom21.sql)	(revision 667583f574672f48a6777c6d3e7e0f6b7a06d3f7)
@@ -1,4 +1,10 @@
 -- SQL statements to update from LAMS 2.1/2.1.1
+
+-- Turn off autocommit, so nothing is committed if there is an error
+SET AUTOCOMMIT = 0;
+
+----------------------Put all sql statements below here-------------------------
+
 CREATE TABLE tl_lantbk11_conditions (
        condition_id BIGINT(20) NOT NULL
 	 , content_uid BIGINT(20)
@@ -9,4 +15,10 @@
                   REFERENCES tl_lantbk11_notebook(uid) ON DELETE CASCADE ON UPDATE CASCADE
 )TYPE=InnoDB;
 
-UPDATE lams_tool SET supports_outputs=1 WHERE tool_signature='lantbk11';
\ No newline at end of file
+UPDATE lams_tool SET supports_outputs=1 WHERE tool_signature='lantbk11';
+
+----------------------Put all sql statements above here-------------------------
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
\ No newline at end of file
Index: lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20081021_updateFrom21.sql
===================================================================
diff -u -r7b79396263b36a933d66390fb9ab12821956d59d -r667583f574672f48a6777c6d3e7e0f6b7a06d3f7
--- lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20081021_updateFrom21.sql	(.../patch20081021_updateFrom21.sql)	(revision 7b79396263b36a933d66390fb9ab12821956d59d)
+++ lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20081021_updateFrom21.sql	(.../patch20081021_updateFrom21.sql)	(revision 667583f574672f48a6777c6d3e7e0f6b7a06d3f7)
@@ -1,5 +1,10 @@
 -- SQL statements to update from LAMS 2.1/2.1.1
 
+-- Turn off autocommit, so nothing is committed if there is an error
+SET AUTOCOMMIT = 0;
+
+----------------------Put all sql statements below here-------------------------
+
 CREATE TABLE tl_lasurv11_conditions (
        condition_id BIGINT(20) NOT NULL
 	 , content_uid BIGINT(20)
@@ -20,4 +25,10 @@
                   REFERENCES tl_lasurv11_question(uid) ON DELETE CASCADE ON UPDATE CASCADE	
 )TYPE=InnoDB;
 
-UPDATE lams_tool SET supports_outputs=1 WHERE tool_signature='lasurv11';
\ No newline at end of file
+UPDATE lams_tool SET supports_outputs=1 WHERE tool_signature='lasurv11';
+
+----------------------Put all sql statements above here-------------------------
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
\ No newline at end of file