Index: lams_build/common.properties =================================================================== RCS file: /usr/local/cvsroot/lams_build/common.properties,v diff -u -r1.44.2.7 -r1.44.2.8 --- lams_build/common.properties 28 Jan 2015 14:49:15 -0000 1.44.2.7 +++ lams_build/common.properties 15 Dec 2015 20:21:38 -0000 1.44.2.8 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_common/db/sql/drop_lams_11_tables.sql,v diff -u -r1.31.2.1 -r1.31.2.2 --- lams_common/db/sql/drop_lams_11_tables.sql 31 Oct 2015 17:39:08 -0000 1.31.2.1 +++ lams_common/db/sql/drop_lams_11_tables.sql 15 Dec 2015 20:21:26 -0000 1.31.2.2 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20150928.sql,v diff -u -r1.1.2.2 -r1.1.2.3 --- lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20150928.sql 5 Oct 2015 16:59:58 -0000 1.1.2.2 +++ lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20150928.sql 15 Dec 2015 20:21:30 -0000 1.1.2.3 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_tool_bbb/src/java/org/lamsfoundation/lams/tool/bbb/dbupdates/patch20150930.sql,v diff -u -r1.1.2.2 -r1.1.2.3 --- lams_tool_bbb/src/java/org/lamsfoundation/lams/tool/bbb/dbupdates/patch20150930.sql 5 Oct 2015 17:00:01 -0000 1.1.2.2 +++ lams_tool_bbb/src/java/org/lamsfoundation/lams/tool/bbb/dbupdates/patch20150930.sql 15 Dec 2015 20:21:42 -0000 1.1.2.3 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20150930.sql,v diff -u -r1.1.2.2 -r1.1.2.3 --- lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20150930.sql 5 Oct 2015 17:00:04 -0000 1.1.2.2 +++ lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20150930.sql 15 Dec 2015 20:21:28 -0000 1.1.2.3 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_tool_eadventure/src/java/org/eucm/lams/tool/eadventure/dbupdates/patch20150930.sql,v diff -u -r1.1.2.2 -r1.1.2.3 --- lams_tool_eadventure/src/java/org/eucm/lams/tool/eadventure/dbupdates/patch20150930.sql 5 Oct 2015 16:59:49 -0000 1.1.2.2 +++ lams_tool_eadventure/src/java/org/eucm/lams/tool/eadventure/dbupdates/patch20150930.sql 15 Dec 2015 20:21:43 -0000 1.1.2.3 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20150930.sql,v diff -u -r1.1.2.2 -r1.1.2.3 --- lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20150930.sql 5 Oct 2015 16:59:54 -0000 1.1.2.2 +++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20150930.sql 15 Dec 2015 20:21:32 -0000 1.1.2.3 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_tool_gmap/src/java/org/lamsfoundation/lams/tool/gmap/dbupdates/patch20150930.sql,v diff -u -r1.1.2.2 -r1.1.2.3 --- lams_tool_gmap/src/java/org/lamsfoundation/lams/tool/gmap/dbupdates/patch20150930.sql 5 Oct 2015 16:59:51 -0000 1.1.2.2 +++ lams_tool_gmap/src/java/org/lamsfoundation/lams/tool/gmap/dbupdates/patch20150930.sql 15 Dec 2015 20:21:36 -0000 1.1.2.3 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20150930.sql,v diff -u -r1.1.2.2 -r1.1.2.3 --- lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20150930.sql 5 Oct 2015 16:40:57 -0000 1.1.2.2 +++ lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20150930.sql 15 Dec 2015 20:21:37 -0000 1.1.2.3 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_tool_imscc/src/java/org/lamsfoundation/lams/tool/commonCartridge/dbupdates/patch20150930.sql,v diff -u -r1.1.2.2 -r1.1.2.3 --- lams_tool_imscc/src/java/org/lamsfoundation/lams/tool/commonCartridge/dbupdates/patch20150930.sql 5 Oct 2015 16:59:56 -0000 1.1.2.2 +++ lams_tool_imscc/src/java/org/lamsfoundation/lams/tool/commonCartridge/dbupdates/patch20150930.sql 15 Dec 2015 20:21:33 -0000 1.1.2.3 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_tool_kaltura/src/java/org/lamsfoundation/lams/tool/kaltura/dbupdates/patch20150930.sql,v diff -u -r1.1.2.2 -r1.1.2.3 --- lams_tool_kaltura/src/java/org/lamsfoundation/lams/tool/kaltura/dbupdates/patch20150930.sql 5 Oct 2015 16:59:50 -0000 1.1.2.2 +++ lams_tool_kaltura/src/java/org/lamsfoundation/lams/tool/kaltura/dbupdates/patch20150930.sql 15 Dec 2015 20:21:40 -0000 1.1.2.3 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20150930.sql,v diff -u -r1.1.2.2 -r1.1.2.3 --- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20150930.sql 5 Oct 2015 16:59:55 -0000 1.1.2.2 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20150930.sql 15 Dec 2015 20:21:35 -0000 1.1.2.3 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20150930.sql,v diff -u -r1.1.2.2 -r1.1.2.3 --- lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20150930.sql 5 Oct 2015 17:00:05 -0000 1.1.2.2 +++ lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20150930.sql 15 Dec 2015 20:21:29 -0000 1.1.2.3 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_tool_leader/src/java/org/lamsfoundation/lams/tool/leaderselection/dbupdates/patch20150930.sql,v diff -u -r1.1.2.2 -r1.1.2.3 --- lams_tool_leader/src/java/org/lamsfoundation/lams/tool/leaderselection/dbupdates/patch20150930.sql 5 Oct 2015 17:00:06 -0000 1.1.2.2 +++ lams_tool_leader/src/java/org/lamsfoundation/lams/tool/leaderselection/dbupdates/patch20150930.sql 15 Dec 2015 20:21:44 -0000 1.1.2.3 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_tool_mindmap/src/java/org/lamsfoundation/lams/tool/mindmap/dbupdates/patch20150930.sql,v diff -u -r1.1.2.2 -r1.1.2.3 --- lams_tool_mindmap/src/java/org/lamsfoundation/lams/tool/mindmap/dbupdates/patch20150930.sql 5 Oct 2015 16:59:57 -0000 1.1.2.2 +++ lams_tool_mindmap/src/java/org/lamsfoundation/lams/tool/mindmap/dbupdates/patch20150930.sql 15 Dec 2015 20:21:45 -0000 1.1.2.3 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20150930.sql,v diff -u -r1.1.2.2 -r1.1.2.3 --- lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20150930.sql 5 Oct 2015 17:00:02 -0000 1.1.2.2 +++ lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20150930.sql 15 Dec 2015 20:21:34 -0000 1.1.2.3 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_tool_pixlr/src/java/org/lamsfoundation/lams/tool/pixlr/dbupdates/patch20150930.sql,v diff -u -r1.1.2.2 -r1.1.2.3 --- lams_tool_pixlr/src/java/org/lamsfoundation/lams/tool/pixlr/dbupdates/patch20150930.sql 5 Oct 2015 16:59:53 -0000 1.1.2.2 +++ lams_tool_pixlr/src/java/org/lamsfoundation/lams/tool/pixlr/dbupdates/patch20150930.sql 15 Dec 2015 20:21:38 -0000 1.1.2.3 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20150930.sql,v diff -u -r1.1 -r1.1.2.1 --- lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20150930.sql 30 Sep 2015 19:35:45 -0000 1.1 +++ lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20150930.sql 15 Dec 2015 20:21:31 -0000 1.1.2.1 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_tool_scribe/src/java/org/lamsfoundation/lams/tool/scribe/dbupdates/patch20150930.sql,v diff -u -r1.1.2.2 -r1.1.2.3 --- lams_tool_scribe/src/java/org/lamsfoundation/lams/tool/scribe/dbupdates/patch20150930.sql 5 Oct 2015 16:59:52 -0000 1.1.2.2 +++ lams_tool_scribe/src/java/org/lamsfoundation/lams/tool/scribe/dbupdates/patch20150930.sql 15 Dec 2015 20:21:39 -0000 1.1.2.3 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/dbupdates/patch20150930.sql,v diff -u -r1.1.2.2 -r1.1.2.3 --- lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/dbupdates/patch20150930.sql 5 Oct 2015 17:00:02 -0000 1.1.2.2 +++ lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/dbupdates/patch20150930.sql 15 Dec 2015 20:21:46 -0000 1.1.2.3 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/dbupdates/patch20151123.sql,v diff -u -r1.1.2.2 -r1.1.2.3 --- lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/dbupdates/patch20151123.sql 23 Nov 2015 12:01:26 -0000 1.1.2.2 +++ lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/dbupdates/patch20151123.sql 15 Dec 2015 20:21:46 -0000 1.1.2.3 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20150930.sql,v diff -u -r1.1.2.2 -r1.1.2.3 --- lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20150930.sql 5 Oct 2015 17:00:03 -0000 1.1.2.2 +++ lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20150930.sql 15 Dec 2015 20:21:26 -0000 1.1.2.3 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20150930.sql,v diff -u -r1.1.2.2 -r1.1.2.3 --- lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20150930.sql 5 Oct 2015 16:59:56 -0000 1.1.2.2 +++ lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20150930.sql 15 Dec 2015 20:21:41 -0000 1.1.2.3 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_tool_wiki/src/java/org/lamsfoundation/lams/tool/wiki/dbupdates/patch20150930.sql,v diff -u -r1.1.2.2 -r1.1.2.3 --- lams_tool_wiki/src/java/org/lamsfoundation/lams/tool/wiki/dbupdates/patch20150930.sql 5 Oct 2015 17:00:00 -0000 1.1.2.2 +++ lams_tool_wiki/src/java/org/lamsfoundation/lams/tool/wiki/dbupdates/patch20150930.sql 15 Dec 2015 20:21:32 -0000 1.1.2.3 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_tool_wookie/src/java/org/lamsfoundation/lams/tool/wookie/dbupdates/patch20150930.sql,v diff -u -r1.1.2.2 -r1.1.2.3 --- lams_tool_wookie/src/java/org/lamsfoundation/lams/tool/wookie/dbupdates/patch20150930.sql 5 Oct 2015 16:59:59 -0000 1.1.2.2 +++ lams_tool_wookie/src/java/org/lamsfoundation/lams/tool/wookie/dbupdates/patch20150930.sql 15 Dec 2015 20:21:27 -0000 1.1.2.3 @@ -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-------------------------