Index: lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20140102.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20140102.sql,v
diff -u -r1.2 -r1.3
--- lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20140102.sql	4 Feb 2014 23:22:22 -0000	1.2
+++ lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20140102.sql	7 Apr 2014 18:45:52 -0000	1.3
@@ -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 1.2 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
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_imscc/src/java/org/lamsfoundation/lams/tool/commonCartridge/dbupdates/patch20140102.sql,v
diff -u -r1.2 -r1.3
--- lams_tool_imscc/src/java/org/lamsfoundation/lams/tool/commonCartridge/dbupdates/patch20140102.sql	4 Feb 2014 23:22:12 -0000	1.2
+++ lams_tool_imscc/src/java/org/lamsfoundation/lams/tool/commonCartridge/dbupdates/patch20140102.sql	7 Apr 2014 18:45:50 -0000	1.3
@@ -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 1.2 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
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20140102.sql,v
diff -u -r1.2 -r1.3
--- lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20140102.sql	4 Feb 2014 23:22:19 -0000	1.2
+++ lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20140102.sql	7 Apr 2014 18:45:49 -0000	1.3
@@ -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 1.2 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
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_videorecorder/src/java/org/lamsfoundation/lams/tool/videoRecorder/dbupdates/patch20140102.sql,v
diff -u -r1.2 -r1.3
--- lams_tool_videorecorder/src/java/org/lamsfoundation/lams/tool/videoRecorder/dbupdates/patch20140102.sql	4 Feb 2014 23:22:15 -0000	1.2
+++ lams_tool_videorecorder/src/java/org/lamsfoundation/lams/tool/videoRecorder/dbupdates/patch20140102.sql	7 Apr 2014 18:45:51 -0000	1.3
@@ -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 1.2 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?