Index: lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20150224.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20150224.sql,v diff -u -r1.1 -r1.2 --- lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20150224.sql 2 Mar 2015 00:37:56 -0000 1.1 +++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20150224.sql 3 Mar 2015 10:47:44 -0000 1.2 @@ -7,9 +7,9 @@ ALTER TABLE `tl_lafrum11_message_seq` ADD COLUMN `thread_message_uid` BIGINT(20) DEFAULT NULL, -ADD INDEX `FKFRUM11MSEQTHREAD` (`thread_message_uid` ASC); +ADD INDEX `fkfrum11mseqthread` (`thread_message_uid` ASC); ALTER TABLE `tl_lafrum11_message_seq` -ADD CONSTRAINT `FKFRUM11MSEQTHREAD` +ADD CONSTRAINT `fkfrum11mseqthread` FOREIGN KEY (`thread_message_uid`) REFERENCES `tl_lafrum11_message` (`uid`) ON DELETE RESTRICT Index: lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20150225.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20150225.sql,v diff -u -r1.1 -r1.2 --- lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20150225.sql 2 Mar 2015 00:37:56 -0000 1.1 +++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20150225.sql 3 Mar 2015 10:47:44 -0000 1.2 @@ -2,7 +2,7 @@ -- the WITH RECURSIVE feature not found in MySQL. -- From http://guilhembichot.blogspot.co.uk/2013/11/with-recursive-and-mysql.html -CREATE PROCEDURE `WITH_EMULATOR`( +CREATE PROCEDURE `with_emulator`( recursive_table varchar(100), initial_SELECT varchar(21845), recursive_SELECT varchar(21845), Index: lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20150226.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20150226.sql,v diff -u -r1.1 -r1.2 --- lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20150226.sql 2 Mar 2015 00:37:56 -0000 1.1 +++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20150226.sql 3 Mar 2015 10:47:44 -0000 1.2 @@ -1,12 +1,12 @@ -CREATE PROCEDURE `TL_LAFRUM11_GET_ALL_THREAD_MESSAGE_UIDS_TMP`() +CREATE PROCEDURE `tl_lafrum11_get_all_thread_message_uids_tmp`() BEGIN -PREPARE stmt FROM "drop temporary table if exists tl_lafrum11_thread_message_uid_temp"; +PREPARE stmt FROM "drop temporary table if exists tl_lafrum11_thread_message_uid_tmp"; EXECUTE stmt; -CALL WITH_EMULATOR( +CALL with_emulator( -"TL_LAFRUM11_ALL_THREAD_MEMBERS_TMP", +"tl_lafrum11_recursive_tmp", "select seq.uid as seq_uid, seq.root_message_uid as topic_uid, seq.message_uid as msg_uid, seq.message_level as message_level, m.body as body, @@ -17,13 +17,13 @@ "select chdseq.uid as seq_uid, chdseq.root_message_uid as topic_uid, chdseq.message_uid as msg_uid, chdseq.message_level as message_level, chdm.body as body, chdm.parent_uid as parent_uid, tm.thread_uid as thread_uid -from TL_LAFRUM11_ALL_THREAD_MEMBERS_TMP tm +from tl_lafrum11_recursive_tmp tm join tl_lafrum11_message_seq chdseq join tl_lafrum11_message chdm where tm.msg_uid = chdm.parent_uid and chdseq.message_uid = chdm.uid;", -"create temporary table tl_lafrum11_thread_message_uid_temp as -(select thread_uid, seq_uid from TL_LAFRUM11_ALL_THREAD_MEMBERS_TMP order by thread_uid)", +"create temporary table tl_lafrum11_thread_message_uid_tmp as +(select thread_uid, seq_uid from tl_lafrum11_recursive_tmp order by thread_uid)", 1000, Index: lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20150227.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20150227.sql,v diff -u -r1.1 -r1.2 --- lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20150227.sql 2 Mar 2015 00:37:56 -0000 1.1 +++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20150227.sql 3 Mar 2015 10:47:44 -0000 1.2 @@ -1,12 +1,12 @@ -CREATE PROCEDURE `TL_LAFRUM11_SET_ALL_THREAD_MESSAGE_UIDS_TMP`() +CREATE PROCEDURE `tl_lafrum11_set_all_thread_message_uids_tmp`() BEGIN declare v_finished int default 0; declare v_thread_uid bigint(20); declare v_seq_uid bigint(20); DECLARE thread_cursor CURSOR FOR - SELECT thread_uid, seq_uid FROM tl_lafrum11_thread_message_uid_temp; + SELECT thread_uid, seq_uid FROM tl_lafrum11_thread_message_uid_tmp; DECLARE CONTINUE HANDLER FOR NOT FOUND SET v_finished = 1; Index: lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20150228.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20150228.sql,v diff -u -r1.1 -r1.2 --- lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20150228.sql 2 Mar 2015 00:37:56 -0000 1.1 +++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20150228.sql 3 Mar 2015 10:47:44 -0000 1.2 @@ -3,15 +3,15 @@ -- --------------------Put all sql statements below here------------------------- -call TL_LAFRUM11_GET_ALL_THREAD_MESSAGE_UIDS_TMP(); -call TL_LAFRUM11_SET_ALL_THREAD_MESSAGE_UIDS_TMP(); +call tl_lafrum11_get_all_thread_message_uids_tmp(); +call tl_lafrum11_set_all_thread_message_uids_tmp(); -drop procedure if exists WITH_EMULATOR; -drop procedure if exists TL_LAFRUM11_SET_ALL_THREAD_MESSAGE_UIDS_TMP; -drop procedure if exists TL_LAFRUM11_GET_ALL_THREAD_MESSAGE_UIDS_TMP; +drop procedure if exists with_emulator; +drop procedure if exists tl_lafrum11_set_all_thread_message_uids_tmp; +drop procedure if exists tl_lafrum11_get_all_thread_message_uids_tmp; -drop temporary table if exists tl_lafrum11_thread_message_uid_temp; -drop temporary table if exists TL_LAFRUM11_ALL_THREAD_MEMBERS_TMP; +drop temporary table if exists tl_lafrum11_thread_message_uid_tmp; +drop temporary table if exists tl_lafrum11_recursive_tmp; -- End of thread id addition patches.