Index: lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20140102.sql =================================================================== diff -u -r4d7dfe83093db060d8edeab425ce01543b38b530 -r36259f9faf48438a30f077ce4b389374bcdda424 --- lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20140102.sql (.../patch20140102.sql) (revision 4d7dfe83093db060d8edeab425ce01543b38b530) +++ lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20140102.sql (.../patch20140102.sql) (revision 36259f9faf48438a30f077ce4b389374bcdda424) @@ -3,6 +3,41 @@ SET FOREIGN_KEY_CHECKS=0; ----------------------Put all sql statements below here------------------------- +-- LDEV-3123 Make all DB tables names to be lowercase +SELECT DATABASE() INTO @db_name FROM DUAL; + +SELECT Count(*) +INTO @exists +FROM information_schema.tables +WHERE table_schema = @db_name + AND table_type = 'BASE TABLE' + AND BINARY table_name = 'tl_laimag10_imageGallery'; + +SET @query = If(@exists>0, + 'RENAME TABLE tl_laimag10_imageGallery TO tl_laimag10_imagegallery', + 'SELECT \'nothing to rename\' status'); + +PREPARE stmt FROM @query; + +EXECUTE stmt; + + +SELECT Count(*) +INTO @exists +FROM information_schema.tables +WHERE table_schema = @db_name + AND table_type = 'BASE TABLE' + AND BINARY table_name = 'tl_laimag10_imageGallery_item'; + +SET @query = If(@exists>0, + 'RENAME TABLE tl_laimag10_imageGallery_item TO tl_laimag10_imagegallery_item', + 'SELECT \'nothing to rename\' status'); + +PREPARE stmt FROM @query; + +EXECUTE stmt; + + -- LDEV-3147 Simplify tools: get rid of instructions tab, define in monitor and offline activity options ALTER TABLE tl_laimag10_imagegallery DROP COLUMN online_instructions; ALTER TABLE tl_laimag10_imagegallery DROP COLUMN offline_instructions; Fisheye: Tag 36259f9faf48438a30f077ce4b389374bcdda424 refers to a dead (removed) revision in file `lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20140401.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_tool_imscc/src/java/org/lamsfoundation/lams/tool/commonCartridge/dbupdates/patch20140102.sql =================================================================== diff -u -r4d7dfe83093db060d8edeab425ce01543b38b530 -r36259f9faf48438a30f077ce4b389374bcdda424 --- lams_tool_imscc/src/java/org/lamsfoundation/lams/tool/commonCartridge/dbupdates/patch20140102.sql (.../patch20140102.sql) (revision 4d7dfe83093db060d8edeab425ce01543b38b530) +++ lams_tool_imscc/src/java/org/lamsfoundation/lams/tool/commonCartridge/dbupdates/patch20140102.sql (.../patch20140102.sql) (revision 36259f9faf48438a30f077ce4b389374bcdda424) @@ -3,6 +3,40 @@ SET FOREIGN_KEY_CHECKS=0; ----------------------Put all sql statements below here------------------------- +-- LDEV-3123 Make all DB tables names to be lowercase +SELECT DATABASE() INTO @db_name FROM DUAL; + +SELECT Count(*) +INTO @exists +FROM information_schema.tables +WHERE table_schema = @db_name + AND table_type = 'BASE TABLE' + AND BINARY table_name = 'tl_laimsc11_commonCartridge'; + +SET @query = If(@exists>0, + 'RENAME TABLE tl_laimsc11_commonCartridge TO tl_laimsc11_commoncartridge', + 'SELECT \'nothing to rename\' status'); + +PREPARE stmt FROM @query; + +EXECUTE stmt; + + +SELECT Count(*) +INTO @exists +FROM information_schema.tables +WHERE table_schema = @db_name + AND table_type = 'BASE TABLE' + AND BINARY table_name = 'tl_laimsc11_commonCartridge_item'; + +SET @query = If(@exists>0, + 'RENAME TABLE tl_laimsc11_commonCartridge_item TO tl_laimsc11_commoncartridge_item', + 'SELECT \'nothing to rename\' status'); + +PREPARE stmt FROM @query; + +EXECUTE stmt; + -- LDEV-3147 Simplify tools: get rid of instructions tab, define in monitor and offline activity options ALTER TABLE tl_laimsc11_commoncartridge DROP COLUMN online_instructions; ALTER TABLE tl_laimsc11_commoncartridge DROP COLUMN offline_instructions; Fisheye: Tag 36259f9faf48438a30f077ce4b389374bcdda424 refers to a dead (removed) revision in file `lams_tool_imscc/src/java/org/lamsfoundation/lams/tool/commonCartridge/dbupdates/patch20140401.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20140102.sql =================================================================== diff -u -r4d7dfe83093db060d8edeab425ce01543b38b530 -r36259f9faf48438a30f077ce4b389374bcdda424 --- lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20140102.sql (.../patch20140102.sql) (revision 4d7dfe83093db060d8edeab425ce01543b38b530) +++ lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20140102.sql (.../patch20140102.sql) (revision 36259f9faf48438a30f077ce4b389374bcdda424) @@ -3,6 +3,41 @@ SET FOREIGN_KEY_CHECKS=0; ----------------------Put all sql statements below here------------------------- +-- LDEV-3123 Make all DB tables names to be lowercase +SELECT DATABASE() INTO @db_name FROM DUAL; + +SELECT Count(*) +INTO @exists +FROM information_schema.tables +WHERE table_schema = @db_name + AND table_type = 'BASE TABLE' + AND BINARY table_name = 'tl_latask10_taskList'; + +SET @query = If(@exists>0, + 'RENAME TABLE tl_latask10_taskList TO tl_latask10_tasklist', + 'SELECT \'nothing to rename\' status'); + +PREPARE stmt FROM @query; + +EXECUTE stmt; + + +SELECT Count(*) +INTO @exists +FROM information_schema.tables +WHERE table_schema = @db_name + AND table_type = 'BASE TABLE' + AND BINARY table_name = 'tl_latask10_taskList_item'; + +SET @query = If(@exists>0, + 'RENAME TABLE tl_latask10_taskList_item TO tl_latask10_tasklist_item', + 'SELECT \'nothing to rename\' status'); + +PREPARE stmt FROM @query; + +EXECUTE stmt; + + -- LDEV-3147 Simplify tools: get rid of instructions tab, define in monitor and offline activity options ALTER TABLE tl_latask10_tasklist DROP COLUMN online_instructions; ALTER TABLE tl_latask10_tasklist DROP COLUMN offline_instructions; Fisheye: Tag 36259f9faf48438a30f077ce4b389374bcdda424 refers to a dead (removed) revision in file `lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20140401.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_tool_videorecorder/src/java/org/lamsfoundation/lams/tool/videoRecorder/dbupdates/patch20140102.sql =================================================================== diff -u -r4d7dfe83093db060d8edeab425ce01543b38b530 -r36259f9faf48438a30f077ce4b389374bcdda424 --- lams_tool_videorecorder/src/java/org/lamsfoundation/lams/tool/videoRecorder/dbupdates/patch20140102.sql (.../patch20140102.sql) (revision 4d7dfe83093db060d8edeab425ce01543b38b530) +++ lams_tool_videorecorder/src/java/org/lamsfoundation/lams/tool/videoRecorder/dbupdates/patch20140102.sql (.../patch20140102.sql) (revision 36259f9faf48438a30f077ce4b389374bcdda424) @@ -3,6 +3,25 @@ SET FOREIGN_KEY_CHECKS=0; ----------------------Put all sql statements below here------------------------- +-- LDEV-3123 Make all DB tables names to be lowercase +SELECT DATABASE() INTO @db_name FROM DUAL; + +SELECT Count(*) +INTO @exists +FROM information_schema.tables +WHERE table_schema = @db_name + AND table_type = 'BASE TABLE' + AND BINARY table_name = 'tl_lavidr10_videoRecorder'; + +SET @query = If(@exists>0, + 'RENAME TABLE tl_lavidr10_videoRecorder TO tl_lavidr10_videorecorder', + 'SELECT \'nothing to rename\' status'); + +PREPARE stmt FROM @query; + +EXECUTE stmt; + + -- LDEV-3147 Simplify tools: get rid of instructions tab, define in monitor and offline activity options ALTER TABLE tl_lavidr10_videorecorder DROP COLUMN online_instructions; ALTER TABLE tl_lavidr10_videorecorder DROP COLUMN offline_instructions; Fisheye: Tag 36259f9faf48438a30f077ce4b389374bcdda424 refers to a dead (removed) revision in file `lams_tool_videorecorder/src/java/org/lamsfoundation/lams/tool/videoRecorder/dbupdates/patch20140401.sql'. Fisheye: No comparison available. Pass `N' to diff?