Changeset 537 for trunk/admin/UpdateTrace.php

Timestamp:

May 12, 2013, 11:21:59 PM (11 years ago)

Author:

chronos

Message:

• Upraveno: Kódování tabulek sjednoceno na utf8 general.

File:

• trunk/admin/UpdateTrace.php (modified) (1 diff)

trunk/admin/UpdateTrace.php

@@ -2532 +2532 @@
 }
 
+function UpdateTo537($Manager)
+{
+  // Set all string collation to utf8 general
+  $DbResult = $Manager->Execute("SHOW TABLES");
+  while($DbRow = $DbResult->fetch_row())
+  {
+    $Manager->Execute("ALTER TABLE `".$DbRow[0]."` CONVERT TO CHARACTER SET utf8"); 
+  }  
+}
+
 $Updates = array(
         498 => array('Revision' => 506, 'Function' => 'UpdateTo506'),
         506 => array('Revision' => 510, 'Function' => 'UpdateTo510'),
-        510 => array('Revision' => 524, 'Function' => 'UpdateTo524'),
+        510 => array('Revision' => 524, 'Function' => 'UpdateTo524'),
+        524 => array('Revision' => 537, 'Function' => 'UpdateTo537'),
 );