Changeset 526 for trunk/admin/Updates.php

Timestamp:

Apr 21, 2013, 10:23:56 PM (11 years ago)

Author:

chronos

Message:

• Upraveno: Tabulka HyperLink přejmenována na obecnější název Action. Odkazy na názvy ikony přepracovány na samostatnou tabulku.
• Upraveno: Funkce týkající se fronty mailů odděleny do samostatného souboru.

File:

• trunk/admin/Updates.php (modified) (2 diffs)

trunk/admin/Updates.php

@@ -239 +239 @@
 }
 
+function UpdateTo526($Manager)
+{
+  $Manager->Execute("ALTER TABLE `Hyperlink` CHANGE `Name` `Title` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL");
+  $Manager->Execute("ALTER TABLE `Hyperlink` ADD `Name` VARCHAR( 255 ) NOT NULL AFTER `Id`");
+  //$Manager->Execute("ALTER TABLE `Hyperlink` ADD UNIQUE ( `Name` )");
+  $Manager->Execute("ALTER TABLE `Hyperlink` ADD `Type` INT NOT NULL AFTER `Title` , ADD INDEX ( `Type` )");
+  $Manager->Execute("RENAME TABLE `Hyperlink` TO `Action` ;");
+  $Manager->Execute("RENAME TABLE `HyperlinkGroup` TO `ActionGroup` ;");
+  $Manager->Execute("CREATE TABLE IF NOT EXISTS `ActionType` (
+      `Id` int(11) NOT NULL AUTO_INCREMENT,
+      `Name` varchar(255) NOT NULL,
+      PRIMARY KEY (`Id`)
+  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
+  
+  INSERT INTO `ActionType` (`Id`, `Name`) VALUES
+  (1, 'Odkaz'),
+  (2, 'Obrázek');");
+  $Manager->Execute("UPDATE `Action` SET `Type` = 1;");
+  $Manager->Execute("ALTER TABLE `Action` ADD FOREIGN KEY ( `Type` ) REFERENCES `ActionType` (".
+    "`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;");
+  $Manager->Execute("UPDATE `Panel` SET `Module` = 'ActionGroup' WHERE `Module` = 'HyperlinkGroup'");
+  $Manager->Execute("CREATE TABLE IF NOT EXISTS `ActionIcon` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Name` varchar(255) NOT NULL,
+  PRIMARY KEY (`Id`)
+) 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("UPDATE `Action` SET `IconFile` = (SELECT `Id` FROM `ActionIcon` WHERE `ActionIcon`.`Name` = `Action`.`IconFile`) ");
+  $Manager->Execute("ALTER TABLE `Action` CHANGE `IconFile` `Icon` INT NULL ");
+  $Manager->Execute("UPDATE `Action` SET `Icon` = NULL WHERE `Icon` = 0");
+  $Manager->Execute("ALTER TABLE `Action` ADD INDEX ( `Icon` ) ");
+  $Manager->Execute("ALTER TABLE `Action` ADD FOREIGN KEY ( `Icon` ) REFERENCES `ActionIcon` (`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;");
+  $Manager->Execute("INSERT INTO `ISMenuItem` (`Id` ,`Name` ,`Parent` ,`Table` ,`IconName`) ".
+    "VALUES (NULL , 'Akce', '23', 'Action', '');");
+}
 
 $Updates = array(
@@ -253 +288 @@
   507 => array('Revision' => 515, 'Function' => 'UpdateTo515'),
   515 => array('Revision' => 517, 'Function' => 'UpdateTo517'),
+  517 => array('Revision' => 526, 'Function' => 'UpdateTo526'),
 );