0, 'RENAME TABLE hs_response_group TO HS_Response_Group', 'SELECT \'nothing to rename\' status'); PREPARE stmt FROM @query; EXECUTE stmt;"); # HS_Permission_Groups # mysql_query("SELECT Count(*) INTO @exists FROM information_schema.tables WHERE table_schema = [".cDBNAME."] AND table_type = 'BASE TABLE' AND table_name = 'hs_permission_groups'; SET @query = If(@exists>0, 'RENAME TABLE hs_permission_groups TO HS_Permission_Groups', 'SELECT \'nothing to rename\' status'); PREPARE stmt FROM @query; EXECUTE stmt;"); # HS_Filter_Group # mysql_query("SELECT Count(*) INTO @exists FROM information_schema.tables WHERE table_schema = [".cDBNAME."] AND table_type = 'BASE TABLE' AND table_name = 'hs_filter_group'; SET @query = If(@exists>0, 'RENAME TABLE hs_filter_group TO HS_Filter_Group', 'SELECT \'nothing to rename\' status'); PREPARE stmt FROM @query; EXECUTE stmt;"); # HS_Migrations # mysql_query("SELECT Count(*) INTO @exists FROM information_schema.tables WHERE table_schema = [".cDBNAME."] AND table_type = 'BASE TABLE' AND table_name = 'hs_migrations'; SET @query = If(@exists>0, 'RENAME TABLE hs_migrations TO HS_Migrations', 'SELECT \'nothing to rename\' status'); PREPARE stmt FROM @query; EXECUTE stmt;"); ########################################## # Deleted in v4 ########################################## # mysql_query("RENAME TABLE `hs_documents_location` TO `HS_Documents_Location`"); //Complete echo "Complete"; ?>