<?php
/**
* If you installed SilverStripe under windows MySQL with the ignore_case feature enabled (as it is by default) then you probably need this.
* It will help you rename all the tables in an SQL Dump back into case sensitivity
*
* Directions:
* set $file to the sqldump.
* Include this class from your _config.php
* If it says "The follow tables aren't accounted for" and lists some tables, add the correct case version of them to the list below, and try again.
*
* If it succeeds, it will print the new SQLDump for you to reimport.
*
* More info:
* http://silverstripe.org/general-questions/show/11285
* http://cosminswiki.com/index.php/MySQL_case_insensitive_table_and_column_names
*
* @author Dean Rather <dean@deanrather.com>
* @version 1.1
* @date 2011-08-03
*/

$file = file_get_contents('../mysqldump.sql');
$defaultTables = "ArchiveWidget
BlogEntry
BlogEntry_Live
Blogentry_Lersions
BlogHolder
BlogHolder_Live
BlogHolder_Versions
BlogTree
BlogTree_Live
BlogTree_Versions
ContactPage
ContactPage_Live
ContactPage_Versions
Email_BounceRecord
ErrorPage
ErrorPage_Live
ErrorPage_Versions
File
Gallery
Group
Group_Members
Group_Roles
HomePage
HomePage_Live
HomePage_Versions
LoginAttempt
Member
MemberPassword
MageComment
Panel
Permission
PermissionRole
PermissionRoleCode
Products
ProductsPage
ProductsPage_Live
ProductsPage_Versions
Products_Live
Products_versions
QueuedEmail
RedirectorPage
RedirectorPage_Live
RedirectorPage_Versions
RSSWidget
SiteConfig
SiteConfig_CreateTopLevelGroups
SiteConfig_EditorGroups
SiteConfig_ViewerGroups
SiteTree
SiteTree_EditorGroups
SiteTree_ImageTracking
SiteTree_LinkTracking
SiteTree_Live
SiteTree_versions
SiteTree_ViewerGroups
TagCloudWidget
TrackBackPing
VirtualPage
VirtualPage_Live
VirtualPage_versions
Widget
WidgetArea
PageComment";

$fixed = explode("\r\n", $defaultTables);
$lower = explode("\r\n", strtolower($defaultTables));

// What tables do I actually have
$database = $databaseConfig['database'];
$sql = "SHOW TABLES FROM `$database`";
DB::connect($databaseConfig);
$result = DB::query($sql);
$actual = array();
foreach($result as $row) {
foreach($row as $table) {
$actual[] = $table;
}
}

// Which tables are not catered for in the default list
$missing = '';
foreach($actual as $actualTable) {
if(array_search($actualTable, $lower)===false) $missing .= "<br />$actualTable";
}
if($missing) {
exit("<b>The follow tables aren't accounted for:</b> $missing");
}

foreach($fixed as $word) {
$file = str_replace(strtolower("`$word`"), "`$word`", $file);
}

exit("<pre>$file</pre>");