Index: lams_build/common.properties
===================================================================
diff -u -rd4997181b2a73dc16bdd0a69932d443fe7dbfbd7 -r504d89d950a4725a3ce25e7ef1932ee6e857de68
--- lams_build/common.properties	(.../common.properties)	(revision d4997181b2a73dc16bdd0a69932d443fe7dbfbd7)
+++ lams_build/common.properties	(.../common.properties)	(revision 504d89d950a4725a3ce25e7ef1932ee6e857de68)
@@ -55,6 +55,7 @@
 #======== END TOOL PROPERTIES =========
 
 #======== DATABASE PROPERTIES =========
+db.port=3306
 db.name=lams
 db.username=lams
 db.password=lamsdemo
@@ -68,7 +69,7 @@
 db.location=C:/lams/database
 
 # To build LAMS using standalone MySQL server, use properties below
-db.url.build=jdbc:mysql://localhost:3306/${db.name}?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&autoReconnect=true&useUnicode=true
+db.url.build=jdbc:mysql://localhost:${db.port}/${db.name}?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&autoReconnect=true&useUnicode=true&useSSL=false
 db.url.init.build=${db.url.build}
 
 # To build LAMS using embedded MySQL server, use properties below
@@ -79,7 +80,7 @@
 #db.url.init.build=${db.url.build}&server.initialize-user=true&createDatabaseIfNotExist=true
 
 # To run LAMS using standalone MySQL server, use properties below
-db.url.run=jdbc:mysql://localhost:3306/${db.name}
+db.url.run=jdbc:mysql://localhost:${db.port}/${db.name}
 
 # To run LAMS using embedded MySQL server, use properties below
 #db.url.run=jdbc:mysql:mxj://localhost:13306/${db.name}
Index: lams_common/db/sql/drop_lams_11_tables.sql
===================================================================
diff -u -r747ca68c982acc647cc5e277ae967489e684d7b4 -r504d89d950a4725a3ce25e7ef1932ee6e857de68
--- lams_common/db/sql/drop_lams_11_tables.sql	(.../drop_lams_11_tables.sql)	(revision 747ca68c982acc647cc5e277ae967489e684d7b4)
+++ lams_common/db/sql/drop_lams_11_tables.sql	(.../drop_lams_11_tables.sql)	(revision 504d89d950a4725a3ce25e7ef1932ee6e857de68)
@@ -69,4 +69,7 @@
 DROP TABLE IF EXISTS lams_quartz_JOB_DETAILS;
 DROP TABLE IF EXISTS lams_quartz_CALENDARS;
 
+-- AutoPatch table
+DROP TABLE IF EXISTS patches;
+
 SET FOREIGN_KEY_CHECKS=1;
Index: lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20150928.sql
===================================================================
diff -u -r50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5 -r504d89d950a4725a3ce25e7ef1932ee6e857de68
--- lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20150928.sql	(.../patch20150928.sql)	(revision 50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5)
+++ lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20150928.sql	(.../patch20150928.sql)	(revision 504d89d950a4725a3ce25e7ef1932ee6e857de68)
@@ -4,7 +4,7 @@
 ----------------------Put all sql statements below here-------------------------
 
 --  LDEV-3564 session_id must be unique
-ALTER IGNORE TABLE tl_laasse10_session ADD UNIQUE (session_id);
+ALTER TABLE tl_laasse10_session ADD UNIQUE (session_id);
 
 ----------------------Put all sql statements above here-------------------------
 
Index: lams_tool_bbb/src/java/org/lamsfoundation/lams/tool/bbb/dbupdates/patch20150930.sql
===================================================================
diff -u -r50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5 -r504d89d950a4725a3ce25e7ef1932ee6e857de68
--- lams_tool_bbb/src/java/org/lamsfoundation/lams/tool/bbb/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5)
+++ lams_tool_bbb/src/java/org/lamsfoundation/lams/tool/bbb/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 504d89d950a4725a3ce25e7ef1932ee6e857de68)
@@ -4,7 +4,7 @@
 ----------------------Put all sql statements below here-------------------------
 
 --  LDEV-3564 tool session id must be unique in tool's session table
-ALTER IGNORE TABLE tl_labbb10_session ADD UNIQUE (session_id);
+ALTER TABLE tl_labbb10_session ADD UNIQUE (session_id);
 
 ----------------------Put all sql statements above here-------------------------
 
Index: lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20150930.sql
===================================================================
diff -u -r50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5 -r504d89d950a4725a3ce25e7ef1932ee6e857de68
--- lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5)
+++ lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 504d89d950a4725a3ce25e7ef1932ee6e857de68)
@@ -4,7 +4,7 @@
 ----------------------Put all sql statements below here-------------------------
 
 --  LDEV-3564 tool session id must be unique in tool's session table
-ALTER IGNORE TABLE tl_lachat11_session ADD UNIQUE (session_id);
+ALTER TABLE tl_lachat11_session ADD UNIQUE (session_id);
 
 ----------------------Put all sql statements above here-------------------------
 
Index: lams_tool_eadventure/src/java/org/eucm/lams/tool/eadventure/dbupdates/patch20150930.sql
===================================================================
diff -u -r50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5 -r504d89d950a4725a3ce25e7ef1932ee6e857de68
--- lams_tool_eadventure/src/java/org/eucm/lams/tool/eadventure/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5)
+++ lams_tool_eadventure/src/java/org/eucm/lams/tool/eadventure/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 504d89d950a4725a3ce25e7ef1932ee6e857de68)
@@ -4,7 +4,7 @@
 ----------------------Put all sql statements below here-------------------------
 
 --  LDEV-3564 tool session id must be unique in tool's session table
-ALTER IGNORE TABLE tl_eueadv10_session ADD UNIQUE (session_id);
+ALTER TABLE tl_eueadv10_session ADD UNIQUE (session_id);
 
 ----------------------Put all sql statements above here-------------------------
 
Index: lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20150930.sql
===================================================================
diff -u -r50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5 -r504d89d950a4725a3ce25e7ef1932ee6e857de68
--- lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5)
+++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 504d89d950a4725a3ce25e7ef1932ee6e857de68)
@@ -4,7 +4,7 @@
 ----------------------Put all sql statements below here-------------------------
 
 --  LDEV-3564 tool session id must be unique in tool's session table
-ALTER IGNORE TABLE tl_lafrum11_tool_session ADD UNIQUE (session_id);
+ALTER TABLE tl_lafrum11_tool_session ADD UNIQUE (session_id);
 
 ----------------------Put all sql statements above here-------------------------
 
Index: lams_tool_gmap/src/java/org/lamsfoundation/lams/tool/gmap/dbupdates/patch20150930.sql
===================================================================
diff -u -r50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5 -r504d89d950a4725a3ce25e7ef1932ee6e857de68
--- lams_tool_gmap/src/java/org/lamsfoundation/lams/tool/gmap/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5)
+++ lams_tool_gmap/src/java/org/lamsfoundation/lams/tool/gmap/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 504d89d950a4725a3ce25e7ef1932ee6e857de68)
@@ -4,7 +4,7 @@
 ----------------------Put all sql statements below here-------------------------
 
 --  LDEV-3564 tool session id must be unique in tool's session table
-ALTER IGNORE TABLE tl_lagmap10_session ADD UNIQUE (session_id);
+ALTER TABLE tl_lagmap10_session ADD UNIQUE (session_id);
 
 ----------------------Put all sql statements above here-------------------------
 
Index: lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20150930.sql
===================================================================
diff -u -r434a2aec5c62876edcb6dc8908896939080f1cf2 -r504d89d950a4725a3ce25e7ef1932ee6e857de68
--- lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 434a2aec5c62876edcb6dc8908896939080f1cf2)
+++ lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 504d89d950a4725a3ce25e7ef1932ee6e857de68)
@@ -4,7 +4,7 @@
 ----------------------Put all sql statements below here-------------------------
 
 --  LDEV-3564 tool session id must be unique in tool's session table
-ALTER IGNORE TABLE tl_laimag10_session ADD UNIQUE (session_id);
+ALTER TABLE tl_laimag10_session ADD UNIQUE (session_id);
 
 ----------------------Put all sql statements above here-------------------------
 
Index: lams_tool_imscc/src/java/org/lamsfoundation/lams/tool/commonCartridge/dbupdates/patch20150930.sql
===================================================================
diff -u -r50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5 -r504d89d950a4725a3ce25e7ef1932ee6e857de68
--- lams_tool_imscc/src/java/org/lamsfoundation/lams/tool/commonCartridge/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5)
+++ lams_tool_imscc/src/java/org/lamsfoundation/lams/tool/commonCartridge/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 504d89d950a4725a3ce25e7ef1932ee6e857de68)
@@ -4,7 +4,7 @@
 ----------------------Put all sql statements below here-------------------------
 
 --  LDEV-3564 tool session id must be unique in tool's session table
-ALTER IGNORE TABLE tl_laimsc11_session ADD UNIQUE (session_id);
+ALTER TABLE tl_laimsc11_session ADD UNIQUE (session_id);
 
 ----------------------Put all sql statements above here-------------------------
 
Index: lams_tool_kaltura/src/java/org/lamsfoundation/lams/tool/kaltura/dbupdates/patch20150930.sql
===================================================================
diff -u -r50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5 -r504d89d950a4725a3ce25e7ef1932ee6e857de68
--- lams_tool_kaltura/src/java/org/lamsfoundation/lams/tool/kaltura/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5)
+++ lams_tool_kaltura/src/java/org/lamsfoundation/lams/tool/kaltura/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 504d89d950a4725a3ce25e7ef1932ee6e857de68)
@@ -4,7 +4,7 @@
 ----------------------Put all sql statements below here-------------------------
 
 --  LDEV-3564 tool session id must be unique in tool's session table
-ALTER IGNORE TABLE tl_lakalt11_session ADD UNIQUE (session_id);
+ALTER TABLE tl_lakalt11_session ADD UNIQUE (session_id);
 
 ----------------------Put all sql statements above here-------------------------
 
Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20150930.sql
===================================================================
diff -u -r50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5 -r504d89d950a4725a3ce25e7ef1932ee6e857de68
--- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5)
+++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 504d89d950a4725a3ce25e7ef1932ee6e857de68)
@@ -4,7 +4,7 @@
 ----------------------Put all sql statements below here-------------------------
 
 --  LDEV-3564 tool session id must be unique in tool's session table
-ALTER IGNORE TABLE tl_laqa11_session ADD UNIQUE (qa_session_id);
+ALTER TABLE tl_laqa11_session ADD UNIQUE (qa_session_id);
 
 ----------------------Put all sql statements above here-------------------------
 
Index: lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20150930.sql
===================================================================
diff -u -r50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5 -r504d89d950a4725a3ce25e7ef1932ee6e857de68
--- lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5)
+++ lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 504d89d950a4725a3ce25e7ef1932ee6e857de68)
@@ -4,7 +4,7 @@
 ----------------------Put all sql statements below here-------------------------
 
 --  LDEV-3564 tool session id must be unique in tool's session table
-ALTER IGNORE TABLE tl_larsrc11_session ADD UNIQUE (session_id);
+ALTER TABLE tl_larsrc11_session ADD UNIQUE (session_id);
 
 ----------------------Put all sql statements above here-------------------------
 
Index: lams_tool_leader/src/java/org/lamsfoundation/lams/tool/leaderselection/dbupdates/patch20150930.sql
===================================================================
diff -u -r50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5 -r504d89d950a4725a3ce25e7ef1932ee6e857de68
--- lams_tool_leader/src/java/org/lamsfoundation/lams/tool/leaderselection/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5)
+++ lams_tool_leader/src/java/org/lamsfoundation/lams/tool/leaderselection/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 504d89d950a4725a3ce25e7ef1932ee6e857de68)
@@ -4,7 +4,7 @@
 ----------------------Put all sql statements below here-------------------------
 
 --  LDEV-3564 tool session id must be unique in tool's session table
-ALTER IGNORE TABLE tl_lalead11_session ADD UNIQUE (session_id);
+ALTER TABLE tl_lalead11_session ADD UNIQUE (session_id);
 
 ----------------------Put all sql statements above here-------------------------
 
Index: lams_tool_mindmap/src/java/org/lamsfoundation/lams/tool/mindmap/dbupdates/patch20150930.sql
===================================================================
diff -u -r50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5 -r504d89d950a4725a3ce25e7ef1932ee6e857de68
--- lams_tool_mindmap/src/java/org/lamsfoundation/lams/tool/mindmap/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5)
+++ lams_tool_mindmap/src/java/org/lamsfoundation/lams/tool/mindmap/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 504d89d950a4725a3ce25e7ef1932ee6e857de68)
@@ -4,7 +4,7 @@
 ----------------------Put all sql statements below here-------------------------
 
 --  LDEV-3564 tool session id must be unique in tool's session table
-ALTER IGNORE TABLE tl_lamind10_session ADD UNIQUE (session_id);
+ALTER TABLE tl_lamind10_session ADD UNIQUE (session_id);
 
 ----------------------Put all sql statements above here-------------------------
 
Index: lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20150930.sql
===================================================================
diff -u -r50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5 -r504d89d950a4725a3ce25e7ef1932ee6e857de68
--- lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5)
+++ lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 504d89d950a4725a3ce25e7ef1932ee6e857de68)
@@ -4,7 +4,7 @@
 ----------------------Put all sql statements below here-------------------------
 
 --  LDEV-3564 tool session id must be unique in tool's session table
-ALTER IGNORE TABLE tl_lantbk11_session ADD UNIQUE (session_id);
+ALTER TABLE tl_lantbk11_session ADD UNIQUE (session_id);
 
 ----------------------Put all sql statements above here-------------------------
 
Index: lams_tool_pixlr/src/java/org/lamsfoundation/lams/tool/pixlr/dbupdates/patch20150930.sql
===================================================================
diff -u -r50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5 -r504d89d950a4725a3ce25e7ef1932ee6e857de68
--- lams_tool_pixlr/src/java/org/lamsfoundation/lams/tool/pixlr/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5)
+++ lams_tool_pixlr/src/java/org/lamsfoundation/lams/tool/pixlr/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 504d89d950a4725a3ce25e7ef1932ee6e857de68)
@@ -4,7 +4,7 @@
 ----------------------Put all sql statements below here-------------------------
 
 --  LDEV-3564 tool session id must be unique in tool's session table
-ALTER IGNORE TABLE tl_lapixl10_session ADD UNIQUE (session_id);
+ALTER TABLE tl_lapixl10_session ADD UNIQUE (session_id);
 
 ----------------------Put all sql statements above here-------------------------
 
Index: lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20150930.sql
===================================================================
diff -u -ra93929c9c7f7f0df676412691f2f8f9d44d201a2 -r504d89d950a4725a3ce25e7ef1932ee6e857de68
--- lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision a93929c9c7f7f0df676412691f2f8f9d44d201a2)
+++ lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 504d89d950a4725a3ce25e7ef1932ee6e857de68)
@@ -4,7 +4,7 @@
 ----------------------Put all sql statements below here-------------------------
 
 --  LDEV-3564 tool session id must be unique in tool's session table
-ALTER IGNORE TABLE tl_laprev11_session ADD UNIQUE (session_id);
+ALTER TABLE tl_laprev11_session ADD UNIQUE (session_id);
 
 ----------------------Put all sql statements above here-------------------------
 
Index: lams_tool_scribe/src/java/org/lamsfoundation/lams/tool/scribe/dbupdates/patch20150930.sql
===================================================================
diff -u -r50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5 -r504d89d950a4725a3ce25e7ef1932ee6e857de68
--- lams_tool_scribe/src/java/org/lamsfoundation/lams/tool/scribe/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5)
+++ lams_tool_scribe/src/java/org/lamsfoundation/lams/tool/scribe/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 504d89d950a4725a3ce25e7ef1932ee6e857de68)
@@ -4,7 +4,7 @@
 ----------------------Put all sql statements below here-------------------------
 
 --  LDEV-3564 tool session id must be unique in tool's session table
-ALTER IGNORE TABLE tl_lascrb11_session ADD UNIQUE (session_id);
+ALTER TABLE tl_lascrb11_session ADD UNIQUE (session_id);
 
 ----------------------Put all sql statements above here-------------------------
 
Index: lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/dbupdates/patch20150930.sql
===================================================================
diff -u -r50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5 -r504d89d950a4725a3ce25e7ef1932ee6e857de68
--- lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5)
+++ lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 504d89d950a4725a3ce25e7ef1932ee6e857de68)
@@ -4,7 +4,7 @@
 ----------------------Put all sql statements below here-------------------------
 
 --  LDEV-3564 tool session id must be unique in tool's session table
-ALTER IGNORE TABLE tl_lasprd10_session ADD UNIQUE (session_id);
+ALTER TABLE tl_lasprd10_session ADD UNIQUE (session_id);
 
 ----------------------Put all sql statements above here-------------------------
 
Index: lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/dbupdates/patch20151123.sql
===================================================================
diff -u -r243d5982cf31edc572dda60167d28515b8e42fef -r504d89d950a4725a3ce25e7ef1932ee6e857de68
--- lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/dbupdates/patch20151123.sql	(.../patch20151123.sql)	(revision 243d5982cf31edc572dda60167d28515b8e42fef)
+++ lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/dbupdates/patch20151123.sql	(.../patch20151123.sql)	(revision 504d89d950a4725a3ce25e7ef1932ee6e857de68)
@@ -4,7 +4,7 @@
 ----------------------Put all sql statements below here-------------------------
 
 --  LDEV-3612 Marks should accept decimal 
-ALTER IGNORE TABLE tl_lasprd10_spreadsheet_mark CHANGE COLUMN marks marks FLOAT NULL DEFAULT NULL;
+ALTER TABLE tl_lasprd10_spreadsheet_mark CHANGE COLUMN marks marks FLOAT NULL DEFAULT NULL;
 
 ----------------------Put all sql statements above here-------------------------
 
Index: lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20150930.sql
===================================================================
diff -u -r50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5 -r504d89d950a4725a3ce25e7ef1932ee6e857de68
--- lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5)
+++ lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 504d89d950a4725a3ce25e7ef1932ee6e857de68)
@@ -4,7 +4,7 @@
 ----------------------Put all sql statements below here-------------------------
 
 --  LDEV-3564 tool session id must be unique in tool's session table
-ALTER IGNORE TABLE tl_lasurv11_session ADD UNIQUE (session_id);
+ALTER TABLE tl_lasurv11_session ADD UNIQUE (session_id);
 
 ----------------------Put all sql statements above here-------------------------
 
Index: lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20150930.sql
===================================================================
diff -u -r50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5 -r504d89d950a4725a3ce25e7ef1932ee6e857de68
--- lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5)
+++ lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 504d89d950a4725a3ce25e7ef1932ee6e857de68)
@@ -4,7 +4,7 @@
 ----------------------Put all sql statements below here-------------------------
 
 --  LDEV-3564 tool session id must be unique in tool's session table
-ALTER IGNORE TABLE tl_latask10_session ADD UNIQUE (session_id);
+ALTER TABLE tl_latask10_session ADD UNIQUE (session_id);
 
 ----------------------Put all sql statements above here-------------------------
 
Index: lams_tool_wiki/src/java/org/lamsfoundation/lams/tool/wiki/dbupdates/patch20150930.sql
===================================================================
diff -u -r50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5 -r504d89d950a4725a3ce25e7ef1932ee6e857de68
--- lams_tool_wiki/src/java/org/lamsfoundation/lams/tool/wiki/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5)
+++ lams_tool_wiki/src/java/org/lamsfoundation/lams/tool/wiki/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 504d89d950a4725a3ce25e7ef1932ee6e857de68)
@@ -4,7 +4,7 @@
 ----------------------Put all sql statements below here-------------------------
 
 --  LDEV-3564 tool session id must be unique in tool's session table
-ALTER IGNORE TABLE tl_lawiki10_session ADD UNIQUE (session_id);
+ALTER TABLE tl_lawiki10_session ADD UNIQUE (session_id);
 
 ----------------------Put all sql statements above here-------------------------
 
Index: lams_tool_wookie/src/java/org/lamsfoundation/lams/tool/wookie/dbupdates/patch20150930.sql
===================================================================
diff -u -r50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5 -r504d89d950a4725a3ce25e7ef1932ee6e857de68
--- lams_tool_wookie/src/java/org/lamsfoundation/lams/tool/wookie/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 50cb113f16003f3e6ae5e1b9826baf5b43e4f7a5)
+++ lams_tool_wookie/src/java/org/lamsfoundation/lams/tool/wookie/dbupdates/patch20150930.sql	(.../patch20150930.sql)	(revision 504d89d950a4725a3ce25e7ef1932ee6e857de68)
@@ -4,7 +4,7 @@
 ----------------------Put all sql statements below here-------------------------
 
 --  LDEV-3564 tool session id must be unique in tool's session table
-ALTER IGNORE TABLE tl_lawook10_session ADD UNIQUE (session_id);
+ALTER TABLE tl_lawook10_session ADD UNIQUE (session_id);
 
 ----------------------Put all sql statements above here-------------------------