Changeset 535

Timestamp:

May 12, 2013, 10:47:04 PM (11 years ago)

Author:

chronos

Message:

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

Location:

trunk

Files:

• Common/Version.php (modified) (1 diff)
• admin/Updates.php (modified) (3 diffs)

trunk/Common/Version.php

@@ -1 +1 @@
 <?php
 
-$Revision = 534; // Subversion revision
-$DatabaseRevision = 527; // SQL structure revision
-$ReleaseTime = '2013-04-24';
+$Revision = 535; // Subversion revision
+$DatabaseRevision = 535; // SQL structure revision
+$ReleaseTime = '2013-05-12';
 
 ?>

trunk/admin/Updates.php

@@ -266 +266 @@
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");
   $Manager->Execute("INSERT INTO `ActionIcon` (SELECT NULL AS `Id`, `IconFile` AS `Name` FROM `Action` WHERE `IconFile` != '' GROUP BY `IconFile`)");
+  $Manager->Execute("ALTER TABLE `Action` CHANGE `IconFile` `IconFile` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL");
   $Manager->Execute("UPDATE `Action` SET `IconFile` = (SELECT `Id` FROM `ActionIcon` WHERE `ActionIcon`.`Name` = `Action`.`IconFile`) ");
   $Manager->Execute("ALTER TABLE `Action` CHANGE `IconFile` `Icon` INT NULL ");
@@ -301 +302 @@
   $Manager->Execute("INSERT INTO `MenuItem` (`Id` ,`Name` ,`Parent` ,`Action` ,`Menu`) ".
     "VALUES (NULL , 'Nabídky', '23', '".$ActionId."', '1');");  
+}
+
+function UpdateTo535($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"); 
+  }  
 }
 
@@ -318 +329 @@
   517 => array('Revision' => 526, 'Function' => 'UpdateTo526'),
   526 => array('Revision' => 527, 'Function' => 'UpdateTo527'),
+  527 => array('Revision' => 535, 'Function' => 'UpdateTo535'),
 );